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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dsl98
Frequent Visitor

Field Parameter in matrix visual- Change of Sequence

Hi all, I was trying to change the sequence of the columns shown in matrix table.

As per screenshot below, it is currently shown as countries (normal fixed columns - ID, MY etc.), then the values of field parameters based on drop down (eg. NTS PY, NTS LT...)

dsl98_0-1721014042931.png

dsl98_1-1721014264076.png

 

However, in the columns, I would prefer to show the field parameter values first, then the markets (eg. NTS PY, then ID MY PH..; then NTS LT, then ID MY PH..). Hope to achieve the visual preference so that I can see each field parameter category at one glance. Thanks! 

2 REPLIES 2
Uzi2019
Super User
Super User

Hi @dsl98 
Try to put your filed parameter category in column then  your country in column of matrix visual.

Uzi2019_0-1721026250607.png

 

I hope by this way you get the desired result.

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
dsl98
Frequent Visitor

Thank you for your reply. I tried but it did not work. If I remove the Values and keep the 2 columns, it will be blank.

dsl98_0-1721029024350.pngdsl98_1-1721029037764.png

 

 

I also drilled up and down using different order of sequence, but it did not work too.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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