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.
Hello Power BI community,
I'm having trouble figuring out how to display what I need for my report. Below is the table I am using for my clustered column chart.
Below is the period and clustered column graphs I am using to visualize the data. Showing the PGs and the values for demand and field by PG and then by period for the drill down.
My issue is that I would like to have a slicer that allows me to toggle between "Demand" "Field" and in addition "Demand - Field" and "Demand vs Field % Variance".
The issue is I am not sure how to do this. I have these as measures now which I use in card view, but I want this to be able to be displayed in a clustered column view, so that I may click the "Demand - Field" button and both the clustered column and line graphs are only shows the values for "Demand-Field"?
Really appreciate any and all help!
There are two way to achieve measure selection, slicer or bookmark
https://community.powerbi.com/t5/Desktop/Bookmark-on-slicer-selection/td-p/307164
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
https://www.youtube.com/watch?v=6tEsu7aZ5Tg
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Thanks for your the learning materials @amitchandak! Unfortunately I am still struggling with the bookmarking aspect.
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 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |