How to place measures in vertically stacked position?

[Koushik0206]

I want to create below view. I've 12 separate measures each for calculated safety stock units, calculated safety stock months, calculated safety stock $ - like these for rest. How can I do that? I know one way to do this is by modifying through Power Query and unpivoting the table. But I'have to add some toggles post this step so would prefer to have this created using measures or without modifying through power query table.

Please help, thanks!

[v-pnaroju-msft · Accepted solution]

Thankyou, @vicky_ , @danextian, for your response.

Hi @Koushik0206,

Thank you for your inquiry on the Microsoft Fabric Community Forum.

Please find attached the screenshot and the PBIX file, which may assist in resolving the issue:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members who face similar queries.

Thank you.

[Koushik0206]

This is really great! I had to make quite a lot of tweaks to have the base data aligned with your solution but the overall apporach worked like a charm. Thank you so much! God bless! 🙂

[danextian]

You said 12 measures, but i am only seeing 4 each for stock units, calculated safety stock months, calculated safety stock $.

[Koushik0206]

Calculated Safety Stock, Calculated Cycle Stock, Max Inventory Level, Min Inventory Level - all these four have outputs in units, months and $. So 4 metrics * 3 unit of measures = 12 measures in total.

[vicky_]

If you've got a matrix or table, go to Format > Values > Options and select the option to show values on rows

[Koushik0206]

This will have all the measures stacked on top of each other like below:

But I want this to be like below: