Color of a multiline chart that depends on a table

[theofech]

Hola,

I'm new on powerBI desktop. I have a multiline chart. I would like that the color of each line depends on a filed that come from my postgresql database. Do you know how can I do this ?

Thanks a lot for you help,

Theo

[Fowmy]

@theofech 

You can use the legend section of the chart to show the color of each line differently.

If this answer doesn't work, please your sample data and the expected

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn results.

[theofech]

@Fowmy  thanks a lot for your help !

OK but I have to manualy choose the color of each line  ! What I would like is that the color is determined by a field of the table. That's a kind of conditonnal format I think, but when I do a line chart, I don't achieve to see the conditionnal format ellipsis (tree dots).

[v-rzhou-msft]

Hi @theofech 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

[v-rzhou-msft · Accepted solution]

Hi @theofech 

You may want to use conditional formatting in Line Charts for multiple lines.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function：Cluster column and line chart

Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Rico Zhou

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