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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Transposing Table and Conditional formating

I have a table, that I need to transpose and perform conditioal formating as shown below

 

Table Converstion.jpg

 

Appreciate your help.

2 REPLIES 2
v-sihou-msft
Employee
Employee

@Anonymous

 

You just need to use a matrix to render your data. Make sure your drill all level down to lowest level in matrix.

 

4.PNG

 

5.PNG

 

Regards,

Anonymous
Not applicable

Requirement is not to drill down, but rather show as I provided the image. We need to add conditional formating Yellow and Green color. Table needs to be transposed. Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.