Skip to main content

Power BI

Completed

Conditional Formatting for Total and Subtotals in Matrices

Vote (5185) Share
's profile image

on 12 Dec 2016 08:57:40

The recent addition of conditional formatting for values is wonderful. However, it would be great to have the ability format subtotals and totals, as the variation on those fields are often even more important to draw attention to.

Administrator on 23 May 2020 01:39:28

Thanks everyone for your votes on this feature! With the April 2020 release of Power BI Desktop this is now available! https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2020-feature-summary/#_Conditional_formatting Please keep commenting on this feature with other feedback, we check the Completed items as well as ones that are still active.

Comments (547)
's profile image Profile Picture

f0f157e8 271f-40ea-90cb-ba6b1c0dbf48 on 05 Jul 2020 23:18:51

RE: Conditional Formatting for Total and Subtotals in Matrices

Hi All i have done with some tricks to apply conditional formatting to total values.
http://sahayasathish.blogspot.sg/2018/05/poer-bi-conditional-formatting-on.html

let me know if its usefull

's profile image Profile Picture

090f412d 531f-42f1-abc9-57d9c903a231 on 05 Jul 2020 23:18:45

RE: Conditional Formatting for Total and Subtotals in Matrices

Agree with everyone, we can't have conditional formatting that doesn't apply to subtotals, it destroys the drill down capability of the matrix. Shouldn't really have to vote on this

's profile image Profile Picture

abcdf854 ba4a-4732-9e85-946c4f97e49f on 05 Jul 2020 23:18:36

RE: Conditional Formatting for Total and Subtotals in Matrices

Any update on getting conditional formatting for table and matrix total rows?

's profile image Profile Picture

6a6826e0 4c24-4c41-b614-ea9b50cc6f76 on 05 Jul 2020 23:18:25

RE: Conditional Formatting for Total and Subtotals in Matrices

we really need this feature- pl release asap

's profile image Profile Picture

3869a0ba 06eb-48ac-a9ef-fec7da1cc439 on 05 Jul 2020 23:18:23

RE: Conditional Formatting for Total and Subtotals in Matrices

Must have!

's profile image Profile Picture

4de54423 0093-4062-bb4f-d85018f5da1c on 05 Jul 2020 23:18:17

RE: Conditional Formatting for Total and Subtotals in Matrices

This isn't just a nice to have feature but a definite must have!

's profile image Profile Picture

6c6ca30a 7bb0-4104-bccb-175ff8577647 on 05 Jul 2020 23:18:08

RE: Conditional Formatting for Total and Subtotals in Matrices

Agree this is a common use for use and we need this desperately

's profile image Profile Picture

a55573ac fa8e-4976-82d7-af0ab1aea2a5 on 05 Jul 2020 23:17:52

RE: Conditional Formatting for Total and Subtotals in Matrices

Conditional formatting in totals and subtotals is a very important feature and we need this desperately. :(

's profile image Profile Picture

3c2bb634 df93-4511-ba4a-7390a04a821f on 05 Jul 2020 23:17:49

RE: Conditional Formatting for Total and Subtotals in Matrices

Agreed. I need to display in thousands just for the totals and there is no way to do this right now. Need this feature.

's profile image Profile Picture

532ce3ce c567-4504-86e3-75f951cbbd1d on 05 Jul 2020 23:17:48

RE: Conditional Formatting for Total and Subtotals in Matrices

come on guys