Forum Discussion
Card Measure as Tree Map Values Field
Hi,
I'm trying to build a visual that uses four cards for a top row of a dashboard with different measures ($ sales, % sales, year over year, and year to date). Below the line of four cards will be a line graph and a tree map. I'd like the end user to click on the card (say $ sales), then the line chart and tree map use the $ sales measure as the value. Then if the end user clicks on % sales, the line graphs and tree maps redraw using % sales as the value. Help is greatly appreciated.
Thank you.
Owen
Hi Anonymous ,
I would use bookmarks and field parameters for this use case. I'd overlay a no fill shape on every measure. Each shape is assigned a bookmark view (wherein an item in the field parameter is selected). Here's a sample pbix - https://drive.google.com/file/d/1KvFIhKEZrxbL_MKOcYDbKD09_sJwJdQP/view?usp=sharing
Demo on youtube - https://youtu.be/fXuYtewItmw
Hi Anonymous ,
As a workaround, we can use a slicer for different results of visuals.
Create a table by entering data.
Then create a measure like the following.
Measure = SWITCH ( SELECTEDVALUE ( 'Table (2)'[Type] ), "Sales($)", [MeasureSales($)], "Sales(%)", [MeasureSales(%)] )Put the measure into the Values of the visual.
When you filter the slicer, the result of the visual will change.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
I would use bookmarks and field parameters for this use case. I'd overlay a no fill shape on every measure. Each shape is assigned a bookmark view (wherein an item in the field parameter is selected). Here's a sample pbix - https://drive.google.com/file/d/1KvFIhKEZrxbL_MKOcYDbKD09_sJwJdQP/view?usp=sharing
Demo on youtube - https://youtu.be/fXuYtewItmw
Hi Anonymous ,
As a workaround, we can use a slicer for different results of visuals.
Create a table by entering data.
Then create a measure like the following.
Measure = SWITCH ( SELECTEDVALUE ( 'Table (2)'[Type] ), "Sales($)", [MeasureSales($)], "Sales(%)", [MeasureSales(%)] )Put the measure into the Values of the visual.
When you filter the slicer, the result of the visual will change.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi danextian, The solution looks great. Once I figured out how to turn on 'field parameters' in the preview features, your idea worked and was implemented. Thanks so much.