New Feature: Slicer to choose which columns to display on chart using Fields Parameter in PowerBI

New Feature : Slicer to choose which column to display on the chart in PowerBI | MiTutorials

PowerBI Released a new Feature in the May 2022 update which is the Field Parameter which lets you choose Dynamic Column and Measures in PowerBI !!

[madhuri]

after 3 days of continuous search finally I am glad I found this. such a crisp and awesome explanation. Thank you!

[abzdel]

was stumped trying to make a dynamic pivot table at work. this helped a ton, thanks man!

[NSLABTUTORIAIS]

Thank you very much. I spent some time looking for this solution on Brazilian sites and nothing. You were my salvation. / Muito obrigado. Eu gastei certo tempo procurando esta solução em sites brasileiros e nada. Voce foi minha salvação.

[oskrcr]

Super helpful video! thank you very much!

[spritualthoughts]

You selected sales profit and city in slicer... If there is no selection of any of these...visual is showing all three... How to keep sales as default even after I am not selecting any of these measures of sales profit and city

[dcpowered]

This is very useful but could you please make another video to show how to filter rows in a table based on slicer selection. For example, based on one column values.

[zzaudeean]

dynamic measure showing result in the table but not in the chart

[jashjacob]

Hi, really useful chart, I did not know we could use columns as well in parameters. I only used it for measures for some reason. Anyways, is there any way that we can retain the number formatting for measures in this kind of parameters? Since we are switching between Qty and $, if we could retain the number formatting for these, it would have been really useful for me. Right now, I am playing around with bookmarks, which is really a pain for me because I have a few cases where there are too many visuals in the same page and chances of bookmarks going wrong are high.

[joschiap]

Thanks for the awesome video. However, when I do this, the axis does not retain the sort. For example, i am charting handled contacts against date... when I switch the field in a bar chart from Date ....to Month Year, instead of sorting in ascending order, it shows the handled contacts descending instead of ascending month year. Any way of changing the default axis sort?

[martinsanchezromero]

Trying to use this feature to add the obtained dynamic field as Values in a Matrix visualization (trying to simulate heatmap were you can choose the variable to display). However, all fields are appearing a blank... Thoughts on this?

[nitinkohad.]

Thanks... very useul video...

How to show measure values in slicer...?

[parikshitkorekar]

In my scenario I have 13-14 columns which are related to particular division. Every division is related to multiple columns. I have put division in slicer and all those columns in Matrix visual. Now I want that whenever i choose a particular division columns related to only those division should appear in the matrix and others columns which are not related to that division should disappear
How can I achieve this?

[sunilaleti]

Is it possible to have numerical columns on dynamic axis list. I'm trying but couldn't build

[lucaretattino]

Nice video, I have a question. Is it possible to save somehow the setting of the report once pubblished? Examlple: one person select to show 3 columns to see in a table. then it logs out from power bi service, how do I save that setting for the next log in in the report so the person does not have to reselect always the columns to use in the table/views?

[shreee]

Can we use Slicer to choose which columns to display on "Table Visual" using Fields Parameter?

[bryceking]

I am using this feature with a scatter plot that has a dynamic x axis, dynamic y axis, and dynamic legend. With regard to the legend, I was wondering if it would be possible to not select a value, thus not grouping by color/legend