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? 

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

Unfortunately, it is really impossible to meet your requirement and there is no proper way to work around. As the measure cannot be treated as category, so we cannot display all values in individual lines, and they will be summed up by default. 

 

Regards,

Frank