Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional formatting totals/subtotals

Dear PowerCommunity,

 

When you try to format a value or symbol based on a value it will not work for the totals and subtotals. I came across this issue a few times in the forum but I have also found the following report (link below) that managed to either do the trick, or format it on the source side, which is not likely because of the difference in language.

 

 

 

Is there indeed a trick for this?

 

Kind regards,

 

Michiel

 

https://app.powerbi.com/view?r=eyJrIjoiZDRmOTA2ODMtMDk4My00YzEzLTkxYjItNTYzZGUwZTgxZWJmIiwidCI6IjU3NGMzZTU2LTQ5MjQtNDAwNC1hZDFhLWQ4NDI3ZTdkYjI0MSIsImMiOjZ9

 

Need Help
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Michiel,

     

    Please don't share anything confidential here.

    That could be only a measure which shows up the Emoji. Please refer to the demo below.

    Measure 9 =
IF ( [Measure 11] <= 70000, UNICHAR ( 128308 ), UNICHAR ( 128309 ) )

    Conditional-formatting-totalssubtotals

     

    Best Regards,

8 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Michiel,

     

    Please don't share anything confidential here.

    That could be only a measure which shows up the Emoji. Please refer to the demo below.

    Measure 9 =
IF ( [Measure 11] <= 70000, UNICHAR ( 128308 ), UNICHAR ( 128309 ) )

    Conditional-formatting-totalssubtotals

     

    Best Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you for your reply/soltuion :) The report is a demo! 

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-jiascu-msft ,

       

      your solution is so good, but after I use it in my report, my collegues said he can't see the blue/red circle on the website, only see a weird circle, do you know the reason?

      Thanks.

      Aiolos Zhao

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi there,

       

      The green and yellow circle unichar codes don't work. Do you know how this report was created? 

       

      Thanks

      • ddunn801's avatar
        ddunn801
        Frequent Visitor
        6 years ago

        Go to Conditional Formatiing, Icons = On, Advanced controls, then Totals only.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Michiel,

     

    How did you ctreated the Matrix on Page 4 ? did you use the default matrix with Power BI or Custom one

    Can you share page 4 with us I would like to see how do you laid out the column?

     

    Thanks,

    Ed Dror

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Dear Anonymous ,

       

      The report is not mine, but a publically available sample report (couldnt find the pbix however).

       

      The matrix is standard but they inserted a background to make it look fancy. Try using Vectr (or paint 8d)! 

       

      Kind regards, 

       

      Michiel

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Michiel,

         

        Thank you

        Oded Dror