Conditional formatting of line graph using measures

[jhauw74]

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 line graph so when the option in the drop down selected that graph representing 1 measure will be hidden.

[Anonymous · Accepted solution]

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]

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]

Hi @jhauw74 ,

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

Best regards,
Community Support Team_ Scott Chang

[ryan_mayu]

@jhauw74 

you can try to create two buttons and use page navigator to switch between two similar pages.

https://learn.microsoft.com/en-us/power-bi/create-reports/button-navigators?tabs=powerbi-desktop?wt....