Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power Bi Experts,
I want to display the grand total text values into red, Region total into blue & Mine total black. As this is hierarchy in rows. How we can do it based conditional formatting.
Solved! Go to Solution.
Hi @prakash11440278 ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Stephen Tao
Hi @prakash11440278 ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Stephen Tao
Hi @prakash11440278 .
you need to create a measure similar to this one:
Formatting = SWITCH(
TRUE();
ISINSCOPE('Table (2)'[Mine]);"black";
ISINSCOPE('Table (2)'[Region]); "blue";
"Red"
)
Be aware that the order of the parameters is important for the final resutl
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix @mahoneypat @amitchandak ,
Thanks for your reply.
I have replicated in my report it is working fine except the total part, which the font colors are not coming as expected.
Hi @prakash11440278 ,
Based on my test, you could set the colors of Grant total and Subtotals separately. In Subtotals, they can no longer be divided.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You could use a measure expression like this in the text conditional format to do that. Replace table with your actual table name.
Text Color = IF(ISFILTERED(Table[Mine]), "Black", IF(ISFILTERED(Table[Region]), "Blue", "Red")
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@prakash11440278 , You have to create a color measure with isinscope and use that in conditional formating with field value option
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
isinscope
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |