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

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

[alikazmi]

This was the best video to help unuderstand difference between slicers + parameter fields. Simply, one reduces rows whereas other the columns.

[markclancy]

Nice video - thank you. The "pacing" was perfect --- concise, but enough detail to easily follow.

[joaoguilhermealvessantos]

Perfect Video, thank you so much. I was struggling trying to create a filter by field/column and your video really helped me.

[hamdyamrizal]

This worked perfectly for me and was excatly what I needed. Thank you very much.

[ZarahDominguez-cfuc]

Thank you so much for this video, it helped me a lot

[shubhamsanas]

Hello,
Thankyou for an eye opening video. Very well-researched and fine-made video this is.

[jimpauls]

Very useful info, to the point, and with extra "goodies" - thank you :)

[kebincui]

Very very clear explanation for this new future.thanks👍🌹

[thugudurgaprasadreddy]

Thanks for the video, are able to apply this column filter on any of visuals like clustered chart, donut chart etc.

[harshchauhan]

Hey this solution is very much helpful
Can we get a video on having a global slicer(slicer that filters from all columns in table)
For eg if we filter by 100 it will check all the columns which have value 100 and display those

[Nikhilmandekar]

This solution is working great. ☺️ Thank you so much for video. But when I am trying to convert that table into chart then its not working as a chart. Can you please advise ?

[satyap]

Can't we make charts for the same...?