Conditional formatting of accent bar colour in Card visual

[David_F64]

This should be easy but I am stumped

I have a simple New Card visual with two values, each with an accent bar. I just want the bar one colour if the value is > 0, a different colour if its < 0

Now in Excel this would be simple, what am I missing in Power BI ?

[rajendraongole1 · Accepted solution]

Hi @David_F64 -If you'd like more control over the logic, you can create a measure that returns a color value based on the value of another measure

ColorMeasure =

IF([Total Hours per Role] > 0, "Green", "Red")

you can replace your measure as i am using total hours per role

In the Visualizations pane, go to Format.>>Under Card, look for Background.>>Click the fx button next to the Background color and set your rules (similar to the Data label method).

Hope it works.

[Kedar_Pande]

@David_F64 ,

From the cards format pane, select the value you want to apply the accent bar color.

Then use fx on accent bar to apply the color rule:

Result:

[Anonymous · Accepted solution]

Hi @David_F64 ,

If you are using a card visual, I recommend using the solution provided by @rajendraongole1 , which allows you to control color changes through measures. If this resolves your issue, please mark @rajendraongole1 's response as "Solved" to close this thread.

If you are considering using other visuals instead, you can achieve a similar effect by using a table visual along with conditional formatting settings.

Best Regards,

Bof

[rajendraongole1 · Accepted solution]

Hi @David_F64 -If you'd like more control over the logic, you can create a measure that returns a color value based on the value of another measure

ColorMeasure =

IF([Total Hours per Role] > 0, "Green", "Red")

you can replace your measure as i am using total hours per role

In the Visualizations pane, go to Format.>>Under Card, look for Background.>>Click the fx button next to the Background color and set your rules (similar to the Data label method).

Hope it works.