Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
but if i switch to Job title in slicer, the chart will show
Note:
Thanks, in advance
Kulchandra
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/
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
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |