Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Formatting Totals and Subtotals - May 2020

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...
General Comment
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

     

  • Oldnewbie's avatar
    Oldnewbie
    Icon for Advocate I rankAdvocate I
    3 years ago

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