Forum Discussion
Dynamic Dimension in bar chart or table
Attached my sample Powerbi and Excel file here
How we can create dynamic dimesion that change dimension based on slicer selection and change values of dimension as well as fact s from fact table.
In my case I have Dimenstion table that contains ID(unique values), Name, Country, Jobtitle
Fact table that contains ID(unique values), fact column.
I need slicer that show as | Country | Job Title | and when i select Country, the chart will show
- Country and Facts,
but if i switch to Job title in slicer, the chart will show
- Job title and facts
Note:
- I am already using Bookmark solution but it takes lots of time to create new bookmark if requirment is changed during run time. I m looking for automated solution so i don't need to worry if dynamic dimestion (column) increased or decreased.
- I have alreay tried (unpivot method), it is not efficent since i have more columns in my dimenstion table then i have mentioned here in example, Unpivot method will increase my table size and also reduce the performace.
- I am using direct query. If any extra tables need to be created i can get it done in direct query (but not unpivot method)
- I tried this ref but could not replicate into my example. please see this link
Thanks, in advance
Kulchandra
3 Replies
- v-diye-msft
Community Support
Hi Anonymous
Did you try the bookmark with selection pane?
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
Posts for your reference:
http://www.victorrocca.com/using-bookmarks-to-show-hide-information-in-your-power-bi-report/
- AnonymousNot applicable
Hi v-diye-msft I forgot to mention. I am already using bookmark solution. This is tedious when changes come run time. If i need to increase Bookmark views then it takes more time to hide unhide elements and create new bookmarks in short time. I am looking for dynamic solution so I don't need to worry if dynamic Dimension column inceases.
Thanks for your reply.
Kul
- v-diye-msft
Community Support
Hi Anonymous
Based on my research, there are no other suggestions on this issue. You can probably raise it to the support team for better advice:
https://powerbi.microsoft.com/en-us/support/