Conditional formatting totals/subtotals

[Anonymous]

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=eyJrIjoiZDRmOTA2ODMtMDk4My00YzEzLTkxYjItNTYzZGUwZTgxZWJmIiwidCI6IjU3N...

[Anonymous]

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]

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]

Michiel,

Thank you

Oded Dror

[v-jiascu-msft · Accepted solution]

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 ) )

Best Regards,

[Anonymous]

Hi there,

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

Thanks

[ddunn801]

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

[Anonymous]

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]

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