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 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!