cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
patrick3
Helper II
Helper II

Matrix - Change "Level" of columns & values in the Matrix

Hi all,

So I've got an issue that seems like it should be simple to change, but I just can't work it out.
I'm using a matrix to display date by day of the month, with different metrics & want to compare 2 months - something like this:

matrix-issue.JPG

However, it's is grouping the metrics by date (bins) (February & March in this case), but I'd like to have the metrics side by side for each month. In a PivotTable, you can just swap "Month" & "Values around, like in this example:

matrix-issue-example.JPG

But I can't figure out how to do that here.

Anyone to the rescue?

Thanks,

Patrick

5 REPLIES 5
DevonVanDam
Helper I
Helper I

Does anyone know if this is possible by now? I also use measures and the problem is not in my data. 

 

Thanks,

Devon

v-yulgu-msft
Microsoft
Microsoft

Hi @patrick3,

 

Suppose the source table structure is similar to below. Under Query Editor mode, select [Leads], [Sales] and [ScvR] fields together, click "Unpivot Columns" to convert table structure.

2.PNG

 

You will get a new table like this:

1.PNG

 

When create the Matrix visual, add [Value Type] on the top of [Date(bins)] in "Columns" section. Also, click the third drill down icon.

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft,

Thanks that's very helpful - not quite the solution I need, as SCvR is a measure rather then a column.

 

Regards,

Patrick

Hi @patrick3,

 

That case, I'm afraid it is not able to change the Matrix structure as you required.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TomMartens
Super User
Super User

Hey,

 

currently this is not possible in the MATRIX view.

 

I recommend to create an idea on ideas.powerbi.com

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors