Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Thanks hashtag_pete
@SamOvermars ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |