Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I created a mesure using my data set in Power BI. Measure = Price/Revenue
I want to add conditional formating for my bar chart. I used Name and Measure for my bar chart.
I want to create conditional format as follow,
Red=<18% |
Yellow=25% |
Green=>30% |
My data set is follow,
Name | Price | Revenue |
A | 200 | 100 |
B | 150 | 50 |
C | 400 | 78 |
D | 500 | 45 |
E | 300 | 20 |
F | 467 | 90 |
I want to add conditional formatting as below. I want to show the shading in my bar chart as below,
Solved! Go to Solution.
Hi @cham ,
Please try to use below setting.
Thanks.
Aiolos Zhao
Proud to be a Super User!
I'm also glad to help you.
Could you please mark my reply as "accepted solution", so other people will know that the topic is sovled.
Thank you.
Aiolos Zhao
Proud to be a Super User!
Hi @cham ,
Please try to use below setting:
Thanks.
Aiolos Zhao
Proud to be a Super User!
Hi @cham ,
Please try to use below setting.
Thanks.
Aiolos Zhao
Proud to be a Super User!
Yes it worked. Thank you so much.
I'm also glad to help you.
Could you please mark my reply as "accepted solution", so other people will know that the topic is sovled.
Thank you.
Aiolos Zhao
Proud to be a Super User!
Hi @AiolosZhao
Can you please help me to do this as well.
I have the following sheet,
Name | Status | Days |
A | Good | 80 |
B | Bad | 30 |
A | Bad | 20 |
A | Good | 50 |
B | Good | 20 |
C | Bad | 90 |
I want to add conditional formatting for the data set above,
Good =Green |
Average=Yellow |
Bad=Red |
as below,
Which chart i can use for this and how can i do the conditional formatting
Hi @cham ,
Please try to use below setting:
Thanks.
Aiolos Zhao
Proud to be a Super User!
Thank you so much
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |