Line Chart having multiple lines?

[SamOvermars]

Hello,
How can I have chart the shows multiple lines based on the data I have ( sample data attached)
I simply want the lines to represent the averages of "Good" in green line for example. "Bad" in red and so on. How can I achieve this in Power BI?

Sample Data:

Good
Bad
Okay
Good
Bad
Okay
Okay
Okay
Okay
Okay
Good
Good

[v-shex-msft · Accepted solution]

HI @SamOvermars,

AFAIk, conditional formatting can use to setting color based on conditions expression but it does not work when you enable legend on the chart.

Tips and tricks for formatting in reports - Power BI | Microsoft Docs
For this scenario, I think you need manually change the data label colors on the format tab(roller icon).
Regards,

Xiaoxn SHeng

[hashtag_pete]

Hello Sam, 

there might be several reasons as to why the visual does not display what you want. 

- From your sample data, I cannot see a connection to the date - did you establish one?

- you should create an explicit measure like countrows and add this to your legend as well as to your values

Does that help? If so, please

• mark this post as a solution
• give kudos

Thanks hashtag_pete

[amitchandak]

@SamOvermars ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.