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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

matrix table - Direct Query

hi all,

is there a possibility to sort by hidden col ?

in matrix table ->the column is "age_desc" (dim) .

I want to sort by "age_id" (hidden) or "age_desc" 

but allowing only sort by :company_code&name .

Thanks, sinayhmatrix2.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

you need to be in the data tab for it to work - but you may have limited access in there because of the direct query.

 

tempsnip.png

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

This may help.

 

On the data tab, you can use 'Sort by Column' that dictates the sort and impacts any visuals that it's in.

 

Capture.JPG

Anonymous
Not applicable

hi, thank you for your response.

It's inaccessible, gray.

matrix3.PNG

Anonymous
Not applicable

you have to select the field you want to sort and this will make it available - then choose the variable from the drop down that you want to sort by.

Anonymous
Not applicable

hi,  Sorry I may not understand though.

It may be related to - direct query?

 

Unable to click - age_desc (2).

And even when I choose "company" (1) a sorting - Still gray 😞

matrix3.PNG

 

Anonymous
Not applicable

you need to be in the data tab for it to work - but you may have limited access in there because of the direct query.

 

tempsnip.png

Anonymous
Not applicable

Wow thank you very much ((:

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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