Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How to output multiple selections on a single chart using a switch statement

Hi,   So I have some selection buttons created from a switch statement in my report. The statement I have used is the following;    Selection = SWITCH( TRUE(), VALUES( 'Metric Selection'[Metric...
Need Help
Show and Tell
  • tex628's avatar
    tex628
    8 years ago
    MeasureQuality =
IF(Selected value('Metric selection'[Metric]="ALL");
Quality[TotalAvgQualityperAgent];
    Blank()
    )

    Then include an "ALL" button aswell? 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Brilliant, that did the trick. Thank you very much :smileyhappy:

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
8 years ago

Good to hear! :)