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
nunavut
Frequent Visitor

Format table to read horizontally

 Capture.PNG

 

 Can someone advise how to transform the table above to a layout below? Thank you. 

 

12001000900150080020002300100095097511001300
JanFebMarAprMayJunJulAugSepOctNovDec
1 ACCEPTED SOLUTION
Eric_Zhang
Employee
Employee


@nunavut wrote:

 Capture.PNG

 

 Can someone advise how to transform the table above to a layout below? Thank you. 

 

1200 1000 900 1500 800 2000 2300 1000 950 975 1100 1300
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

@nunavut

You can use a Matrix visual by setting the matrix column as Month hierarchy.

Capture.PNG

View solution in original post

1 REPLY 1
Eric_Zhang
Employee
Employee


@nunavut wrote:

 Capture.PNG

 

 Can someone advise how to transform the table above to a layout below? Thank you. 

 

1200 1000 900 1500 800 2000 2300 1000 950 975 1100 1300
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

@nunavut

You can use a Matrix visual by setting the matrix column as Month hierarchy.

Capture.PNG

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.