Forum Discussion

Shamatix's avatar
Shamatix
Post Partisan
4 years ago
Solved

Advanced Conditional Formatting / Calculations

Hi there,   So I have received a task I find somewhat impossible and would love some help. I have a matrix looking like this:    Expanded: What I want to achieve is the following: ...
Need Help
Show and Tell
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Shamatix ,

     

    According to my understanding, HASONEFILTER can be used to specify the result displayed by subtotal and change the color in the latest version of the desktop, and the conditional formatting function cannot be used for row subtotal.

    Matrix: conditional formatting on subtotal rows - Microsoft Power BI Community


    You can also post your idea here. If there are too many votes, Microsoft will officially add this feature in the next update. Hope to help you.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Shamatix ,

 

According to your description, you can create a measure, apply it to "Conditional Formatting", and then set subtotal to red. The reference is as follows:

Measure = IF(MAX('Table'[Category])="Category1","black","red")


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Shamatix's avatar
Shamatix
Post Partisan
4 years ago

Hi there,

 

Thanks a ton for your answer, however there is a slight misunderstanding I think.

I have added a customer column to your pbix file, but for some reason I cant attach a pbix file in this reply? How did you manage?

Can you do the Category1 "header" black numbers as well? The subitems are great, however the Category1 header is still red?

 

I have attached an updated pbix file.

The change I did to your data:

 

Best regards

 

 

 

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Shamatix ,

     

    Do you mean that Category1 header is still black? 

     

    Check the screenshot below, you can attach the pbix file you provided.


    Best Regards,
    Henry

     

    • Shamatix's avatar
      Shamatix
      Post Partisan
      4 years ago

      Hi there,

       

      No. 

      The Category1 numbers are red, eventho the numbers are black.

      I want the numbers in the category one to also be black 

      The numbers: 14951, 14400, 551 are all red in your pbix file, those I want black (only one Category1) just like it's subitems are black 🙂 

    • Shamatix's avatar
      Shamatix
      Post Partisan
      4 years ago

      Sorry I cant find that button.

      Sadly I still havnt found a way to make the header of category 1 black aswell :S

       

      • v-henryk-mstf's avatar
        v-henryk-mstf
        Community Support
        4 years ago

        Hi Shamatix ,

         

        According to my understanding, HASONEFILTER can be used to specify the result displayed by subtotal and change the color in the latest version of the desktop, and the conditional formatting function cannot be used for row subtotal.

        Matrix: conditional formatting on subtotal rows - Microsoft Power BI Community


        You can also post your idea here. If there are too many votes, Microsoft will officially add this feature in the next update. Hope to help you.


        Best Regards,
        Henry


        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.