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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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