How can I apply conditional color formatting to a line chart with 2 variables in y axis?

[danielagr]

Hi,

I'm currently working on a report where I have a line chart visual which markers color according to some rules I set using the conditional format functionality (Shown in picture). I want to add a second measure to the y axis, so that the chart shows the performance of both metrics (metrics have the same units). However whenever I add more than one variable I noticed the functionaly to change the color of the markers by using conditional formatting is disabled, and only one color can be picked for each y axis variable . Has someone been able to fix this? conditional formatting
 

[Anonymous]

Hi @danielagr 

An idea similar to yours has already been proposed. You can vote to support this idea.

Allow conditional formatting in of lines line char... - Microsoft Fabric Community

Best Regards,

Jayleny

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

[danextian]

Hi @danielagr 

Conditional formatting being disabled when more than one measure is added is expected. As a workaround, you will need to use separate measures which value appears or returns blank depending on some conditions and assign a color to them.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...