Forum Discussion
Helper IConditional 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 line graph so when the option in the drop down selected that graph representing 1 measure will be hidden.
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 ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
ryan_mayuSuper User
you can try to create two buttons and use page navigator to switch between two similar pages.
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 ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
