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.
Hi,
I have to draw a single line chart which has different colors for values above an upper limit, a second color for values between the lower and upper limits and third color for values below lower limit.
Kind Regards,
Ashish
Hi ..
This is definitely not the best solution, but give a try. Change it to column chart and add a conditional column that have the values (Above limit, below limit, ...) and use it as legend as the picture below. Below 1 is black and above 1 is green.
Cheers,
Alaeddin
Hello, I like this idea, but how did you add the conditions?
hi there ..
Just add a new column to your dataset with a simple if statment. Let's say your threshold is 1, then it should be something like:
New column = if(column > 1 , "High" , "Low")
Then put this new column in the legend so the the bars will be colored according to the value if it's higher or lower than the threshold.
Cheers,
Alaeddin
Hello, I like this idea, but how did you add the conditions?
Hi @ashish_soni,
There are no such visual for your requriement. You can submit a requirement here. Thanks for understanding.
Best Regards,
Angelia
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |