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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
daydream1989
Helper I
Helper I

How to create a table with several rows

Hi, anyone knows how to create this kind of table in power BI desktop?

 

daydream1989_0-1666671739397.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@daydream1989 ,Matrix visual Switch values to Rows or  Show values on row. Year and month on Columns.

 

amitchandak_0-1666673069882.png

 

for more complex display

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Matrix Visual: https://www.youtube.com/watch?v=M5PvQUy-L_4&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=28

 

 

View solution in original post

2 REPLIES 2
Thennarasu_R
Responsive Resident
Responsive Resident

Help Matrix Visual

amitchandak
Super User
Super User

@daydream1989 ,Matrix visual Switch values to Rows or  Show values on row. Year and month on Columns.

 

amitchandak_0-1666673069882.png

 

for more complex display

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Matrix Visual: https://www.youtube.com/watch?v=M5PvQUy-L_4&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=28

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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