Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello All,
I have a clustered bar chart and having different values
Sales1, Sales 2, Sales 3 .
Now I need to change the color for each bar based on thier value, But I see there is no custom color option for this chart.
Could any one suggest how to do this
Solved! Go to Solution.
Hi @Anonymous ,
Please use the IF() or SWITCH() functions to create similar measure and use it as a conditional format for visuals.
Measure =
VAR _total = SUM('Table'[Value])
VAR _colour =
SWITCH(
TRUE(),
_total>=5000 && _total<=6000,"Blue",
_total<5000, "Red",
_total>6000, "Green"
)
return
_colour
Attached PBIX file for reference.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @Anonymous ,
Please use the IF() or SWITCH() functions to create similar measure and use it as a conditional format for visuals.
Measure =
VAR _total = SUM('Table'[Value])
VAR _colour =
SWITCH(
TRUE(),
_total>=5000 && _total<=6000,"Blue",
_total<5000, "Red",
_total>6000, "Green"
)
return
_colour
Attached PBIX file for reference.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
you can change the color by going to the Format your Visual then go columns and create a expression for your data bar color
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
95 | |
88 | |
70 |
User | Count |
---|---|
165 | |
131 | |
129 | |
102 | |
98 |