Multiple series line chart with conditional formatting for line color

Question

Hi All,&nbsp;I'm trying to get multiple lines chart like with using column in legend (below) but I would like to have a freedom to use conditional formatting for changing series colors. In Tableau it is really easy to do it, as there there is seperate field for defining detial and color of plot.&nbsp;I failed with getting what I want by using standard PBI line chart. Perhaps anyone ise familiar with a custom line chart which allows me to create desire&nbsp;&nbsp;

lbendlin · Answer

I failed with getting what I want by using standard PBI line chart
Can you please elaborate - this is relatively standard functionality. What have you tried and where are you stuck?

zbpor · Answer

Hi lbendlin&nbsp;,&nbsp;I have dragged and dropped column to the legend field to break down the chart tu multiple series (Attached image above). Now I would like to instead of relying of auto-generated line colors, define my own condition for coloring series.&nbsp;

lbendlin · Answer

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

zbpor · Answer

Hi&nbsp;lbendlin,I have attached PBI report which is based on PBI's sample dataset&nbsp;Test report.I would like to apply condition formatting to line coloring, and not change each line color indivually.&nbsp;&nbsp;&nbsp;

lbendlin · Answer

First step is to create a measure or calculated column to define the color. In your case a calculated column is sufficient.
Color = SWITCH(financials[Country],"Canada","#118DFF","France","#12239E","Germany","#E66C37","Mexico","#6B007B","#E044A7")
Then you can apply that field in your formatting. Well, you could if that feature would work. I was really sorprised that this is either not enabled or still broken from the implementation of the new formatting pane.&nbsp;

Ironically it makes it look like it works for the data labels. But when you apply the rule it will be ignored.
&nbsp;

But when you apply the rule it will be ignored.

&nbsp;
So yes, this is definitely broken. Sorry!
&nbsp;

Forum Discussion

Multiple series line chart with conditional formatting for line color

8 Replies

Related content

Conditional Formatting

Conditional Formatting

Conditional Formatting using DAX

Condition formatting

Conditional Formatting