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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dsl98
Regular 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!!!

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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