Forum Discussion
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...
MeasureQuality = IF(Selected value('Metric selection'[Metric]="ALL"); Quality[TotalAvgQualityperAgent];
Blank()
)Then include an "ALL" button aswell?
tex628
Community Champion
Community ChampionI dont know if this will work but you could try something like this:
MeasureQuality =
IF(Selected value('Metric selection'[Metric]);
Blank();
Quality[TotalAvgQualityperAgent]
)This should return blank() if metric selection is filtered and otherwise show the Quality value.
Create one measure for each value and include them in the linechart.
Br,
J
Thank you. This logically sounds promising. However I am receiving error when adding both to the values pane;
Ive tried changing the blank() to 0 but this still prompts same error. Any ideas?
- tex628
MeasureQuality = IF(Selected value('Metric selection'[Metric]<>Blank()); Blank(); Quality[TotalAvgQualityperAgent] )Try this! :)
- tex628
Jesus, im not paying attention... like this instead:
MeasureQuality = IF(Selected value('Metric selection'[Metric])<>Blank(); Blank(); Quality[TotalAvgQualityperAgent] )