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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.