Sorting values in Matrix

[Jessica_17]

Hello All,

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

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?

[Anonymous · Accepted solution]

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]

@Jessica_17 it is not possible. 

[Jessica_17]

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