Card Measure as Tree Map Values Field

[Anonymous]

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

[danextian · Accepted solution]

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 

[Anonymous]

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. 

[Anonymous · Accepted solution]

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.

[danextian · Accepted solution]

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