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
Tlotly
Resolver II
Resolver II

show columns of a matrix like a pivot instead of hierarchy

Good day

 

I have a matrix with 2 columns and I want to show them like I would do in excel pivot. See below. 

Tlotly_3-1644399872103.png

But they're currently showing as a hierachy, which I don't want. How do I achieve this? Columns are Meeting Date and FN

Tlotly_1-1644399683185.png

when drilled up:

Tlotly_4-1644399990298.png

Thanks

Matlotlo

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Tlotly , Use expand icon the reverse square Y icon. I think you need to have the month and then FN in column and then use Expand icon and save

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Tlotly , Use expand icon the reverse square Y icon. I think you need to have the month and then FN in column and then use Expand icon and save

@amitchandak  Sorted. Thank you so much

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.