Forum Discussion
Help with adding measures into columns
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 🙂
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.
2 Replies
- v-xulin-mstfCommunity Support
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.
- amitchandakSuper User
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#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc