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? 

tex628's avatar
tex628
Icon for Community Champion rankCommunity 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,

J

 

 

Anonymous's avatar
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's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    8 years ago
    MeasureQuality =
IF(Selected value('Metric selection'[Metric]<>Blank());
Blank();
Quality[TotalAvgQualityperAgent]
)

    Try this! :) 

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

      Jesus, im not paying attention... like this instead:

       

      MeasureQuality =
IF(Selected value('Metric selection'[Metric])<>Blank();
Blank();
Quality[TotalAvgQualityperAgent]
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        lol yep I did sus it, hence I deleted my post.

         

        So looks like it tries to pass in multple values from 'Selection' when not choosing anything. See below;

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        I would have thought this would default to 0 if no value/selection was chosen as per my switch statement above. Any ideas?

         

        (btw thanks for all your help thus far)