Forum Discussion

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

8 years ago

MeasureQuality =
IF(Selected value('Metric selection'[Metric]="ALL");
Quality[TotalAvgQualityperAgent];
Blank()
)

Then include an "ALL" button aswell?

tex628

Community Champion

8 years ago

I 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,

Anonymous
Not applicable
8 years ago
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
  Community Champion
  8 years ago
  MeasureQuality = IF(Selected value('Metric selection'[Metric]<>Blank()); Blank(); Quality[TotalAvgQualityperAgent] )
  Try this! :)
  - tex628
    Community Champion
    8 years ago
    Jesus, im not paying attention... like this instead:
    
    MeasureQuality = IF(Selected value('Metric selection'[Metric])<>Blank(); Blank(); Quality[TotalAvgQualityperAgent] )