Having trouble with displaying what I want

[Anonymous]

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!

[amitchandak]

There are two way to achieve measure selection, slicer  or bookmark

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

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

[Anonymous]

Thanks for your the learning materials @amitchandak! Unfortunately I am still struggling with the bookmarking aspect.