Forum Discussion

jhauw74's avatar
jhauw74
Icon for Helper I rankHelper I
1 year ago
Solved

Conditional formatting of line graph using measures

Hi experts - is there a way I can control the line graph colour change using the drop down menu? Or is there a way to combine this in a single measure? I want to remove or hide 1 measure from the lin...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jhauw74 ,

    You can create field parameter for your drop down menu and then switch the measure based on the option, which may look as follows:

     

     

    OptionMeasure = 
SWITCH(
    [Parameter],
    "ID", [IDMeasure],
    "Value", [ValueMeasure],
    BLANK()
)


     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jhauw74 ,

You can create field parameter for your drop down menu and then switch the measure based on the option, which may look as follows:

 

 

OptionMeasure = 
SWITCH(
    [Parameter],
    "ID", [IDMeasure],
    "Value", [ValueMeasure],
    BLANK()
)


 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

  • jhauw74's avatar
    jhauw74
    Icon for Helper I rankHelper I
    1 year ago

    Hi Scott - this is sounds what I am looking for - are you able to  give me step by step as to where I can get the field parameter?

     

    Josh.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi jhauw74 ,

      It is in the power bi modeling tab, click New parameter:


      Best regards,
      Community Support Team_ Scott Chang