Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! 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.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 50 | |
| 40 | |
| 37 | |
| 14 | |
| 14 |
| User | Count |
|---|---|
| 86 | |
| 71 | |
| 38 | |
| 29 | |
| 26 |