Connect/sync 3 matrix

[Anonymous]

Hi there,

I have the following matrix in excel. In the first part the numbers represent months and within each month 2 measures are displayed ("Ventas Netas" and "Utilidad Bruta"). Right next another 3 measures but instead of having them per month, now they are YTD. Finally, a last measure ("Margen Bruto") is displayed month by month.

I thought of doing 3 matrix and overlap them to get the same visual effect but I am wondering if there is any way to "sync" them so that if the rows are reordered in one of them the other 2 matrix would be reordered as well.

[amitchandak]

@Anonymous , Complex Hybrid format. There are a few workarounds if you want to use Matrix. Or check for custom visual

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

Custome visuals : https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

[Anonymous]

@amitchandak  I tried the first solution out and it worked but there is something off. I would like to sort all rows by "ventas netas" but I cannot. Is there any way I can use one of the measure over there to sort by the matrix?

Thanks in advance

[Anonymous]

Hi @Anonymous ,

It's not supported to sort the matrix by specified column.

You may vote for this idea.

https://ideas.powerbi.com/ideas/idea/?ideaid=05c64cd1-c0d0-44d3-bceb-21f4acc0e548 

Best Regards,

Jay

[Anonymous]

I tried the first solution out and it worked but there is something off. I would like to sort all rows by "ventas netas" but I cannot. Is there any way I can use one of the measure over there to sort by the matrix?