cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors