Forum Discussion
Conditional format data bar using table no option to change colors for different range
Hi,
I created table using Student and Score in power bi. For Score, I am using Conditional formattin/Data bars but this option only has one option for color... Positive Bar and Negative Bar. I don't see any options to have different colors for different range of Scores, for example, if score is below 70 I want red bar, if between 71 and 80 yellow bar and over 80 green bar. I know that I can use other bar charts, but I have 6 other columns I need to bring in so wanted to use Conditional formatting/Data bars option using a Table. Is this possible? Thanks
Hi Anonymous ,
Sorry, for Data Bars it is currently not possible.
For the effects you want different colors, you can try the background color of conditional formatting. You can create dynamic measures to get different colors for different numeric intervals.
Apply conditional table formatting in Power BI - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
Sorry, for Data Bars it is currently not possible.
For the effects you want different colors, you can try the background color of conditional formatting. You can create dynamic measures to get different colors for different numeric intervals.
Apply conditional table formatting in Power BI - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.