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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Jessica_17
Helper IV
Helper IV

Sorting values in Matrix

Hello All,

I have a Power BI matrix table like this in the Screenshot,

Jessica_17_0-1731093390875.png

Now the ask is, they want to sort according % CYA or $ CYA of either 1H or 2H not with total FY, and when we click on it, it basically just selects the column it does not sort, how can we resolve this or have a workaround for it, similarly we have columns with quarter, month and weeks too, where we have to apply same sorting application in those matrix visuals too.

 

Can anyone please help me in this?

1 ACCEPTED SOLUTION
v-kongfanf-msft
Community Support
Community Support

Hi @Jessica_17 ,

 

You can try modifying the matrix's corresponding capabilities.json file, which is automatically generated when the visual object is created. Tell the host which data types the visual object accepts, which customizable properties to place in the properties pane, and any other information needed to create the visual object.

 

Refer to below document:
Capabilities and properties of Power BI visuals - Power BI | Microsoft Learn

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-kongfanf-msft
Community Support
Community Support

Hi @Jessica_17 ,

 

You can try modifying the matrix's corresponding capabilities.json file, which is automatically generated when the visual object is created. Tell the host which data types the visual object accepts, which customizable properties to place in the properties pane, and any other information needed to create the visual object.

 

Refer to below document:
Capabilities and properties of Power BI visuals - Power BI | Microsoft Learn

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k
Super User
Super User

@Jessica_17 it is not possible. 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

HI @parry2k 
Is there no workaround or custom visual for this?

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.