A little secret to rock your YouTube subscribers
Get Free YouTube Subscribers, Views and Likes

Power BI - Slicers - Filter table by rows and columns- uses New parameter Fields option

Follow
Data For Knowledge

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

posted by guiaculcu