Skip to main content

Power BI

Needs Votes

Conditional formatting for data bars in matrix visual

Vote (23) Share
Akash's profile image

Akash on 19 Jun 2017 20:52:25

Hi i see new update for table data bars but all the bars in green i wanted to change the bar colors based on conditions. Please include this feature.

Comments (9)
Akash's profile image Profile Picture

Tom Neal on 19 Oct 2022 18:33:36

RE: Conditional formatting for data bars in matrix visual

A basic feature which would make such a visual impact. Would love to see this added.

Akash's profile image Profile Picture

John Zurflueh on 08 Apr 2022 19:53:18

RE: Conditional formatting for data bars in matrix visual

Seems like something so basic (that I can easily do in T**leau)

Akash's profile image Profile Picture

Romain S on 27 Jan 2021 08:02:44

RE: Conditional formatting for data bars in matrix visual

And for tables

Akash's profile image Profile Picture

Abhijeet Ghosh on 21 Sep 2020 09:38:18

RE: Conditional formatting for data bars in matrix visual

I second with the request. This is a very essential feature. I came across requests with this requirement many a times. Please include this feature. Thanks !

Here is an example of one of the requirement:

https://community.powerbi.com/t5/Desktop/Conditional-formatting-of-data-bars-in-Power-BI-table-visual/m-p/1383868#U1383868

Akash's profile image Profile Picture

Mark N on 05 Jul 2020 23:59:00

RE: Conditional formatting for data bars in matrix visual

Also would help to allow different colors per column.

Akash's profile image Profile Picture

Sriram on 05 Jul 2020 23:41:53

RE: Conditional formatting for data bars in matrix visual

Yes, this feature is extremely useful and also for completeness and consistency ,given that we can achieve this in regular bar charts

Akash's profile image Profile Picture

Srinivas on 05 Jul 2020 23:22:46

RE: Conditional formatting for data bars in matrix visual

We are looking for updates!

Akash's profile image Profile Picture

Power BI User on 05 Jul 2020 23:06:40

RE: Conditional formatting for data bars in matrix visual

'Yes, Its a very much needed feature to showcase the data bars with different colors based on the range. Say for example I have a column with values between 0 to 100. I wanted to have data bars with different colors as per the below conditions
Blue -> if (value) between 0 to 30,
Amber -> if (value) between 31 to 60,
Green -> if (value) between 61 to 100.

Please provide this feature at the earliest.

---- Rajkumar Allepu.

Akash's profile image Profile Picture

Power BI User on 05 Jul 2020 22:56:17

RE: Conditional formatting for data bars in matrix visual

Agree, and must be able to set values for the min & max values - now one of the colors is only set if value i negative - Not good.