Forum Discussion
Conditional Formatting for Data Bars color?
Using Data Bars on a matrix is very helpful, HOWEVER, it does not appear that there is a way to apply any conditional formatting to the color of the bar itself?
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#add-data-bars
Is there anyway to use conditional formating like how the background color can change?
I would like my bars to be green >=90%
yellow >=70% <=89%
red if <70%
I don't see anyway to accomplish that.
HI sasdfasdfsad you can achieve this by following this steps
Step 1: Create a Percentage Column
In here i have created this Profit% column
Profit% = DIVIDE( [TotalProfit], CALCULATE( [TotalProfit], ALL(financials) ) )Step 2: Create a measure for conditional color
Performance Color = SWITCH(TRUE(), [Profit%] >= 0.2, "Green", [Profit%] >= 0.15, "Yellow", [Profit%] < 0.12, "Red", "Gray" )This one is for your conditions
Performance Color = SWITCH(TRUE(), [Your Percentage Field] >= 0.9, "Green", [Your Percentage Field] >= 0.7, "Yellow", [Your Percentage Field] < 0.7, "Red", "Gray" )Step 3: Create a visual and select your column for Conditional formating
Step 4: Set you measure here
Results: In my case i have update my conditions point to fit my data
Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
5 Replies
- CookistadorSuper User
Hi sasdfasdfsad
You can perform some conditional formatting:
My advice, would be to create a dax measure to achieve that
If you have some dummy data, do not hesistate to share them with us, we could create the dax measure for you 😉
- RoyelSuper User
HI sasdfasdfsad you can achieve this by following this steps
Step 1: Create a Percentage Column
In here i have created this Profit% column
Profit% = DIVIDE( [TotalProfit], CALCULATE( [TotalProfit], ALL(financials) ) )Step 2: Create a measure for conditional color
Performance Color = SWITCH(TRUE(), [Profit%] >= 0.2, "Green", [Profit%] >= 0.15, "Yellow", [Profit%] < 0.12, "Red", "Gray" )This one is for your conditions
Performance Color = SWITCH(TRUE(), [Your Percentage Field] >= 0.9, "Green", [Your Percentage Field] >= 0.7, "Yellow", [Your Percentage Field] < 0.7, "Red", "Gray" )Step 3: Create a visual and select your column for Conditional formating
Step 4: Set you measure here
Results: In my case i have update my conditions point to fit my data
Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
- v-priyankataCommunity Support
Hi sasdfasdfsad
Thank you for reaching out to the Microsoft Fabric Forum Community.
Cookistador Royel Thanks for the inputs.
I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.
- v-priyankataCommunity Support
Hi sasdfasdfsad
I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.
- v-priyankataCommunity Support
Hi sasdfasdfsad
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.