Forum Discussion
Power BI - Analysis Services - Pivot Matrix
In Power BI, I am using Analysis Services tabular model as a source. How can I pivot my matrix in desktop? I can't seem to drop a measure in the rows. I understand there is a limitation in doing so. Does anyone have any ideas on how I can accomplish this? Thanks!
Hi southgrad10
You can try this setting: Switch values to rows
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
4 Replies
Hi southgrad10
For a matrix visual, Rows and Columns expect to have columns, you can put measures in Values.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!The measures are in the Values, but I want them in Rows, instead. It won't let me do that, but I understand that is how Power BI is designed. I'm just wondering if there is a work around.
Hi southgrad10
You can try this setting: Switch values to rows
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
