Skip to main content

Power BI

Completed

conditional formatting in tables

Vote (892) Share
marcelo's profile image

marcelo on 21 Aug 2015 09:07:01

It was implemented in charts but not in tables or matrixes.

Administrator on 31 May 2016 23:23:27

We released conditional formatting in tables with our May release of Power BI Desktop. Give it a try and let us know what you think. You can learn more about how to use it in our latest blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/.

Comments (166)
marcelo's profile image Profile Picture

d319e163 98c9-4dd5-9648-4b84f26cb577 on 05 Jul 2020 22:13:56

RE: conditional formatting in tables

You need to add this ability on individual columns and rows. It is useful to add funcionality for the whole table, but to compete with other BI products you really need a column and row level of detail.

marcelo's profile image Profile Picture

2b769fd7 9654-47ee-a22f-72533af7baef on 05 Jul 2020 22:13:21

RE: conditional formatting in tables

a non negotiable ...

marcelo's profile image Profile Picture

f2f782bd d0e7-42f8-b44e-68828bb89f53 on 05 Jul 2020 22:13:12

RE: conditional formatting in tables

Colour by Columns & Rows, OR at the very least, allow us to have grid lines. The Power BI Matrix is sore on the eyes when you look at a large data set. I just want to know which row a value belongs to without getting a headache.

marcelo's profile image Profile Picture

ad029e17 27bf-4edf-92a9-7df0c090ed04 on 05 Jul 2020 22:13:10

RE: conditional formatting in tables

Mandatory to say the least. All of the basic, analytic functionality of Excel should be in Power BI by default.

marcelo's profile image Profile Picture

be0c3a53 9f66-4658-bbd6-4de4ddad544f on 05 Jul 2020 22:12:37

RE: conditional formatting in tables

this is paramount!! Shocked its not a part of it yet. I wouldve bought power bi today had this been possible, however, now I have to buy a different product.

marcelo's profile image Profile Picture

b00e4bd9 4e67-4953-ad06-6aa639f06362 on 05 Jul 2020 22:12:33

RE: conditional formatting in tables

Important indeed!

marcelo's profile image Profile Picture

c86e44ea 5ac5-41ab-9a46-d11f9704bde3 on 05 Jul 2020 22:12:16

RE: conditional formatting in tables

How about negative numbers colored red as a start?

marcelo's profile image Profile Picture

8d6a071e 0f50-4fc4-8a2f-813aeb861dff on 05 Jul 2020 22:11:20

RE: conditional formatting in tables

This is a must to create dashboards who highlight the important items!

marcelo's profile image Profile Picture

ec93e1ef eadf-4b5e-9766-66d80bfbbb64 on 05 Jul 2020 22:11:08

RE: conditional formatting in tables

When is this planned to get released

marcelo's profile image Profile Picture

d3c9b79a 19f3-45f2-8f60-1c447d28143e on 05 Jul 2020 22:11:05

RE: conditional formatting in tables

Absolutely critical. This is one of the only things holding me back from using PowerBI for all reports.