Help with adding measures into columns

[Anonymous]

Hi everyone.

I need your assistance with one small thing.

I have this table that the measures 1 2 and 3 are already in rows and the columns Feb, Mar and Apr are the values for the month.

Is there anyway to have for example instead of Mar having another extra column called YTD?

Thank you in advance for your help 🙂

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

Maybe it is not supported to add YTD column with each month.

You can create a new table with YTD and slicer to compare the values for each month.

Best Regards,

Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , For measure on the row you have the option "Show on row" in matrix

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

To have YTD ate column with pivot, you need a hybrid table

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