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.
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
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.
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.
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?
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 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?
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?
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"
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
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
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!
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.
dynamic measure showing result in the table but not in the chart
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
Super helpful video! thank you very much!
I love it ! Thank you
So awesome thank you!
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.
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?
Thanks nice Explanation
Thanks a lot dear
Awesome work
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 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?
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?
Can we use Slicer to choose which columns to display on "Table Visual" using Fields Parameter?
Yes!
Thanks... very useul video...
How to show measure values in slicer...?
Did you try using the measures in the parameter ?
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
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