topic Conditional formatting of accent bar colour in Card visual in Desktop

Conditional formatting of accent bar colour in Card visual

David_F64 — Mon, 23 Sep 2024 06:29:56 GMT

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 ?

Re: Conditional formatting of accent bar colour in Card visual

rajendraongole1 — Mon, 23 Sep 2024 06:54:07 GMT

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.

Re: Conditional formatting of accent bar colour in Card visual

Anonymous — Fri, 27 Sep 2024 06:45:28 GMT

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

Re: Conditional formatting of accent bar colour in Card visual

Kedar_Pande — Fri, 27 Sep 2024 07:10:36 GMT

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: