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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Help with matrix. Show detail and don't summarize

I'm working on a report using a live connection to an SSAS model.  I would like to create a table/matrix which shows the transaction month as a column header and then the dates of each transaction as the values.  A matrix gives me the format I would like, but I'm not sure how to have it list each transaction date instead of doing an aggregate.  The image below is what I currently have, but it's only showing the earliest date.

 

ADB8335_0-1717441126941.png

 

1 ACCEPTED SOLUTION

Ah my bad - 
if you just want to SHOW the values, and not have anything else, then you can try creating a measure to return the values as a string (formatted so that it's one date per line). 
Here's a sample measure:

Dates as List = IF(HASONEVALUE('Table'[M / Y]), CONCATENATEX('Table', 'Table'[Dates], UNICHAR(10)))

vicky__0-1717539883058.png

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@vicky_   Thanks for the help.  However, I would like the dates to be listed directly underneath the month vertically, not horizontally.  Not sure if this is possible, since different months could have a different number of dates.  This is how it shows in Power BI using your suggestion:

 

ADB8335_0-1717518452934.png

 

Here is how I would like the data to look:

 

ADB8335_1-1717518663709.png

 

Ah my bad - 
if you just want to SHOW the values, and not have anything else, then you can try creating a measure to return the values as a string (formatted so that it's one date per line). 
Here's a sample measure:

Dates as List = IF(HASONEVALUE('Table'[M / Y]), CONCATENATEX('Table', 'Table'[Dates], UNICHAR(10)))

vicky__0-1717539883058.png

 

vicky_
Super User
Super User

You need to set up your matrix like so by putting both the month and the date in the column field:

vicky__0-1717453575598.png

Note - if you've got a date table (and haven't disabled the auto-date heirarchy), there you can just pop the heirarchy in the columns area.

vicky__1-1717453689428.png

Either way, you can then simply drill down with the fork icon to show the month and day in the headers

vicky__2-1717453730023.png

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

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.

Top Solution Authors