Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.