cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamOvermars
Frequent Visitor

Line Chart having multiple lines?

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?

download.png

 

Sample Data:

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

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
hashtag_pete
Helper I
Helper I

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
Super User
Super User

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

Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!