cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnyip
Solution Specialist
Solution Specialist

How can I apply conditional formatting on the "rows" of a matrix

I come across the following table in Excel and want to replicate it in PowerBI.

johnyip_1-1671432851635.png

 

I understand that the yellow part involves "cell merge" and should not be replicate-able in PowerBI. And hence I would like to replicate the table at least like the following at the "To" side:

 

johnyip_0-1671433575660.png

 

Any ideas how to achieve that in PowerBI? I tried conditional formatting but it seems that it cannot be applied on "rows".

 

I would be appreciated when someone can answer my question if there is a solution to this. Would like to know it as well if there is a way to replicate the "cell merge" part of the table.

 

1 ACCEPTED SOLUTION
Mahesh0016
Solution Sage
Solution Sage

Mahesh0016_0-1671434761495.pngMahesh0016_1-1671434823102.png

>> Create Bg_Time Measure >> Plot Column in table Visual >> Right Click on Time Column >> Expand Conditional Formatting >> Background Color >> Give measure formatting.

View solution in original post

2 REPLIES 2
Mahesh0016
Solution Sage
Solution Sage

Mahesh0016_0-1671434761495.pngMahesh0016_1-1671434823102.png

>> Create Bg_Time Measure >> Plot Column in table Visual >> Right Click on Time Column >> Expand Conditional Formatting >> Background Color >> Give measure formatting.

YES! This is actually what I want to achieve, many thanks for your help!

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors