In Power BI, an example of how to use slicers to filter a table by rows and uses the 'New parameter - Fields' option to create a slicer to filter by columns. This allows a table to be filtered by both rows and columns.
The 'New parameter - Fields' option was issued in preview by Microsoft in the May 2022 update. Used in this video from time 03:05 onwards.
Timings:
00:00 Introduction
00:45 Create table and slicer to allow filter on rows
03:05 Add new parameter field option to reports (if still in preview)
04:10 Set up new parameter field to allow filter on columns
06:05 Update table to take new parameter
07:50 Beware - order of selection from slicer dictates order of columns in table
#powerbi #powerbislicers #filtertable #powerbifieldsparameter #powerbitutorial #data #datavisualisation #powerbitips
7 авг 2024