Это видео недоступно.
Сожалеем об этом.
New Feature: Slicer to choose which columns to display on chart using Fields Parameter in PowerBI
HTML-код
- Опубликовано: 17 май 2022
- 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 !!
after 3 days of continuous search finally I am glad I found this. such a crisp and awesome explanation. Thank you!
was stumped trying to make a dynamic pivot table at work. this helped a ton, thanks man!
So awesome thank you!
Super helpful video! thank you very much!
Thanks a lot dear
Awesome work
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.
Thanks nice Explanation
dynamic measure showing result in the table but not in the chart
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.
Hey - did you figure this one out?
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
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?
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?
You might have missed some step please recheck
Did you ever find a fix for this? I am having a similar issue, when I display the dynamic axis as a table it looks perfect but when I change the visualization to any chart like column or line it's just blank. The legend displays the correct values but the visualization itself is blank
Thanks... very useul video...
How to show measure values in slicer...?
Did you try using the measures in the parameter ?
Is it possible to have numerical columns on dynamic axis list. I'm trying but couldn't build
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?
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
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?
You can select the columns that you want to display on the Power BI desktop and publish the report. On Service you will see the same filters applied whenever anybody logins.
@@MITutorials
Thank you for the fast answer!
this ok, but let's say that person A wants to see column 1 2 3 6 while B 1 2 3 5 and I use as starting showing columns 1 2 3, A will add 6 and b will add 5. How do I set that when A will log again it will already see 1 2 3 and 6 and B 1 2 3 and 5? is there a way?
Thank you
On your PBIX file - Go to FILE -> OPTIONS & SETTINGS -> OPTIONS under CURRENT FILE TAB -> Report settings uncheck "Don't allow end users to save filters"
@@MITutorials wow, true, I will test it asap, thank you! an
Can we use Slicer to choose which columns to display on "Table Visual" using Fields Parameter?
Yes!
I love it ! Thank you