Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
I have a table that I have developed in report builder (patinated report).
It has Rows and columns where 1 column is Transpose of its values.
Now I want to perform conditional formatting on this column based on the column names.
For those values where I have Blank in the matrix - I am unable to apply any color, tried adding 0 by to empty valued but did not work.
Is there a way where I can simply color entire columns based on column names irrespective of values?
I want something like this and colour is based on Names(transpose to column)
Instead i am getting this:
Any inputs or help please ?
used ReportItems! instead of Fields!Time_In.Value in switch
If you want to report on things that aren't there you need to use disconnected tables and/or crossjoins.