Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
rdesai2
Regular Visitor

conditional Color formatting based on column names in report Builder (which is transpose)

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)

rdesai2_0-1675380544175.png

 

Instead i am getting this: 

rdesai2_1-1675380608527.png

 

Any inputs or help please ? 

2 REPLIES 2
rdesai2
Regular Visitor

used ReportItems! instead of Fields!Time_In.Value in switch 

lbendlin
Super User
Super User

If you want to report on things that aren't there you need to use disconnected tables and/or crossjoins.

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors