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