Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Line Charts with Filter

Hello,   I have the following three measures I want to show as a line chart:    MeasureA = CALCULATE(SUM(Table1[Value1]), Table1[Layer] = "A") MeasureB = CALCULATE(SUM(Table1[Value1]), Tabl...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Pikachu-Power ,

     

    Like this?

    Or like this?(In this case, only two lines can be returned according to the user's choice.)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

 

Please create one more measure with the if or switch function. then pass the measure in the value section of the visual.

 

Ex: If (selectedmeasure = A, A, if selectedMeasrue = B, C)

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad