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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
mofu1401
Helper I
Helper I

how to format change the format of table data

Dear all

 

I have this matrix, is there a way to show in the another different format..anything that is easier to read instead of scrolling?

Current:

Current18.JPG

expected result or something similar

expected18.JPG

Attached is the file

18sample.pbix

 

Thank you.

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @mofu1401 
I'm not sure that I understood what you are trying to do, but yes you can switch the table to a horizontal Matrix :

Ritaf1983_0-1737177337160.pngRitaf1983_1-1737177382012.png

The updated pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
mofu1401
Helper I
Helper I

@Ritaf1983 yes, that was what I am looking for. Thank you 😊

@Ritaf1983 

can seek your advice for the following?

how to have row - Customer >> Month

 

AA.JPG

 

Thank you.

Hi again 🙂
This is a simple "Rename for the visual" :

Ritaf1983_0-1737208942808.png

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
shafiz_p
Super User
Super User

Hi @mofu1401  To visualize time intelligence calculation, it is better to use matrix visual. Use customer as a slicer, month-year as row and measures in values.

shafiz_p_0-1737178630934.png

This way you can limit the number of rows to visual. 

 

Hope this helps!!

Ritaf1983
Super User
Super User

Hi @mofu1401 
I'm not sure that I understood what you are trying to do, but yes you can switch the table to a horizontal Matrix :

Ritaf1983_0-1737177337160.pngRitaf1983_1-1737177382012.png

The updated pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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