Multiple series line chart with conditional formatting for line color

[zbpor]

Hi All,

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. 

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

[lbendlin]

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]

Hi @lbendlin ,

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.

[lbendlin]

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-...
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]

Hi @lbendlin,

I have attached PBI report which is based on PBI's sample dataset Test report.

I would like to apply condition formatting to line coloring, and not change each line color indivually.

[lbendlin]

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. 

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

But when you apply the rule it will be ignored.

So yes, this is definitely broken. Sorry!

[zbpor]

Hi @lbendlin ,

Thanks for your reply.

Yeah, this is what I was expcting.

Do ye remember if that option was available before they changed formatting pane?

Beacause if so, I could report that to MS.

BR

Zbigniew Porzych

[lbendlin]

Yes, I think this qualifies as an issue.  You can raise it at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

[zbpor]

Thanks @lbendlin.

I didn't know there is a possibility to raise Pro ticket.