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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mohammedshajith
Frequent Visitor

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

Hi Team,
 

I am facing an issue when trying to change the level of "season code" and "store code". The Sum of sales here is "Measure" and not a column, I have seen a workaround using power query unpivoting when the values are columns in table.But that is not working for measure. Can anyone please help you sort out this issue. Thanks in advance

 

mohammedshajith_0-1713508124390.png

 

1 ACCEPTED SOLUTION

Hello @mohammedshajith 

 

Are you able to download the file from the shared link.

 

Regards

sanalytics

View solution in original post

12 REPLIES 12
sanalytics
Super User
Super User

@mohammedshajith 

 

Not grasp your requirement properly. It will be great if you provide your input screenshot and output screenshot so that we can try from our end

 

Regards

sanalytics

 

This is my requirement.

mohammedshajith_3-1713514256267.png

 

 

Hello @mohammedshajith 

 

Can we use a thick green line instead of green double sided arrow?
Are you satisfied with below screenshot

sanalytics_0-1713515424207.png

if you are then let me know i will share the pbix file with you.

 

Regards

sanalytics

If it is your solution then please like and accept it as solution

Hi,
I want the titles sales quantity needs to go up and Region name needs to come down. That means sales central area and quanity central area as separate column names.

Hello @mohammedshajith 

Some like that below screenshot

sanalytics_0-1713516301939.png

 

Regards

sanalytics

If it is your solution then please like and accept it as solution

almost can you share me the Pbix file. thanks

Yes..Below is the pbix file.

https://dropfiles.org/W10Tqxy1
Please dont forget to give kudos and accept this answer as solution.

 

Regards

sanalytics

If it is your solution then please like and accept it as solution

 

 

link not working can you reshare again please

mohammedshajith_0-1713518010943.png

 

@mohammedshajith 

Something is going wrong with that link..
Can you please try the below one please

https://we.tl/t-OmhMRUYiim

Hello @mohammedshajith 

 

Are you able to download the file from the shared link.

 

Regards

sanalytics

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors