Conditional Formatting Totals and Subtotals - May 2020

[MarciaBaptista]

In "Power BI Desktop April 2020 Feature Summary", it was said that conditional formatting would also work for totals and subtotals, but it is not working for subtotals.

"...On top of this, we are releasing several other features, including rectangular lasso select across visuals, conditional formatting for totals and subtotals, Direct Query..."

[amitchandak]

@MarciaBaptista , I see an option under conditional formatting for a background color for a Matrix.

Go to file -> About and check the version, is that latest

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2020-feature-summary/

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/

[MarciaBaptista]

Hello!

Please see my answer for @ Pragati11!

Tanks!

[Pragati11]

HI @MarciaBaptista ,

Just wanted to check if your Power BI is up-to-date to the latest May 2020 version?

I can see these additional functionalities at my end.

If I didn't understand you question, try sharing some screenshots for your query.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[MarciaBaptista]

Hi @Pragati11 !

[MarciaBaptista]

Hi @Pragati11!

My version is updated until May / 2020.

I will put some examples:

I would like it to look like this (as in Excel):

Excel Closed:

Excel Open:

In Power BI, I didn't get the same result. With the April update, it got much better, but still need the option "Subtotals Only"

Tanks,

MarciaBaptista

[Pragati11]

Hi @MarciaBaptista ,

The Subtotals in a Matrix visual are a kind of TOTALS only, done at Row level or Column level:

So, under conditional formatting, you get following options:

The TOTALS in the above window appky to both Totals and Sub-totals in your matrix.

But yes to completly answer your question, can you share some sample data and screenshots from Power BI on what is causing the issue.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Oldnewbie]

Awesome! I was trying to figure out solution for a different probelm and this solved it.

[MarciaBaptista]

Hi @Pragati11!

I configured the matrix as follows:

The result of the matrix is like this.
Closed:

Open:

That is, when it is closed it does not consider as subtotal.

Tanks.