Forum Discussion

ritanoori's avatar
ritanoori
Icon for Resolver I rankResolver I
6 years ago
Solved

Tornado visual legend- Measure

Hello everyone, 

I'm using Tornado Visual and wondering if I can add my measures in values to legends as well? so purple and green bars can be explained easily to end user. 

Thank you. 

Need Help

3 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi ritanoori ,

     

    You can't add a Mesure to a LEGEND in the chart. LEGEND always accepts a column.

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    6 years ago

    A workaround for this is creating a custom legend and then writing a single measure that switches depending on the legend value. 

    I would looks something along the lines of this:

    Create table:

    Category
    CM
    CM-1


    Measure:

    SwitchMeasure =
SWITCH( SELECTEDVALUE( 'Table'[Category] ) ;
"CM" ; [Net Exposure Cm vs CM...] ;
"CM-1" ; [Net Exposure Cm-1 vs C...]
)


    / J