Forum Discussion

rampie's avatar
rampie
Icon for Kudo Commander rankKudo Commander
8 months ago

Matrix column order with Calculation Groups (Measures grouped under Calculation Items instead of the

Hi everyone, I’m working with a Calculation Group for Time Intelligence in Power BI. My goal is to avoid creating separate measures like LY, YTD, MTD, QTD, LYTD, etc. for every base measure (we ha...
Tips and Tricks
v-sgandrathi's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
8 months ago

Hi rampie,

 

Thank you danextian for your prompt response to the query.

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help

 

Thank you.

rampie's avatar
rampie
Icon for Kudo Commander rankKudo Commander
8 months ago

Hi v-sgandrathi 
the contribution is valid and works as described. However, I don’t see it as the most viable approach when dealing with multiple metrics or when trying to replicate the same layout across different metric groups.

Maintaining a manual table introduces additional overhead and reduces the dynamic nature of the model, especially at scale.

As of today, there is still no native way in Power BI to achieve this behavior in the Matrix visual, similar to how Excel allows swapping column hierarchies.

I’ve just published an idea requesting this feature, any support by voting would be greatly appreciated.

 

https://community.fabric.microsoft.com/t5/Fabric-Ideas/Epic-Idea-Allow-swapping-column-grouping-hierarchy-in-Matrix/idi-p/4914771