Forum Discussion
Conditional Formatting for Data Bars color?
- 11 months ago
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!
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.
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.