Showing results for 
Search instead for 
Did you mean: 
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)



Instead i am getting this: 



Any inputs or help please ? 

Regular Visitor

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

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

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Power BI Dev Camp Session 32

Ted's Dev Camp - March 30, 2023

In this session, we'll examine important design issues and decisions that arise when developing with Power BI embedding.

Top Solution Authors