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
7 months ago

Hi rampie,

 

You’re right, the workaround does work, but Power BI Matrix visuals don’t currently allow you to swap the hierarchy between Measures and Calculation Group items like you can in Excel pivot tables. Using manual or disconnected tables can add extra maintenance and may not be ideal for larger or more dynamic models.

Thank you for submitting this as a feature request in the Ideas forum. Your feedback is helpful for the product team to understand real-world modeling needs.

Fabric Ideas - Microsoft Fabric Community
If you have any further questions or need assistance, please feel free to let us know.

Thank you.

v-sgandrathi's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
7 months ago

Hi rampie,

 

Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help. 

 

Thank you.