Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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,
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
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
Michiel,
Thank you
Oded Dror
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,
Hi there,
The green and yellow circle unichar codes don't work. Do you know how this report was created?
Thanks
Go to Conditional Formatiing, Icons = On, Advanced controls, then Totals only.
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
Proud to be a Super User!
Thank you for your reply/soltuion 🙂 The report is a demo!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |