Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
I want to display the subtotals and totals only for the column "Amount in Doc Curr" and hide for all other columns. Please let me know how to do this!
Solved! Go to Solution.
@AishwaryaS , create a measure that has font color the same as the background color and use that in conditional formatting using field value for the two measures
color = Switch(True() ,
isinscope(Table[Reference]), "Black",
"red"
)
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
https://xxlbi.com/blog/new-dax-function-isinscope/
@AishwaryaS , create a measure that has font color the same as the background color and use that in conditional formatting using field value for the two measures
color = Switch(True() ,
isinscope(Table[Reference]), "Black",
"red"
)
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...