Forum Discussion
Columns and Values in Matrix - reverse order
Hi all,
First post here as I literally cannot find a solution to this anywhere at all.
I have a Matrix with 2 measures, Sales and Sales vs. Budget. These span across 4 weeks, 21,22,23 an 24.
In the matrix I have the measures as 'values' and the week as 'columns' as per below:
However, I want to order it the other way round. So we look at each measure across each week, rather than each week across each measure. As per the below that I would usually do in excel:
Is this possible and if so how would I do this?
Many thanks.
7 Replies
Should be able to use a disconnected table trick for that. Here is an example:
Hi HarryBailey ,
To achieve something similar to as per your 2nd screenshot, you will need a column in your data which has 2 values:
- Sales
- Sales vs Budget
Because you can't move a measure to the columns in Matrix.
Also, it will be nice to have some screenshot of the smaple data or may be .pbix file, in order to suggest a calculation.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Thank you for getting back to me, the problem I have is, I am using about 4 different sourcrs of data. I only included 2 above for simplicity. For instance, I've got 1 TY data set, 1 LY, 1 Budget and 1 forecast. These are all different. I get that I would need to use a new column with all of my desired measures in, but how would I combines these from multiple data sources?
Hi HarryBailey ,
To let us know more about your scenario, please show us some sample data (or .pbix) and the results you expect.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there any solution to this?
I have exactly the same problem where I want to get from a matrix visual that looks like this:
|column 1 | column 2 |
|value 1 | value 2|value 1 | value 2|
----------------------------------------------------------
Row 1
Row 2
To a matrix visual that looks like this instead:
|value 1 | value 2 |
|column 1 |column 2|column 1 |column 2|
----------------------------------------------------------
Row 1
Row 2
I don't know why you can do this in a pivot table in excel, but not in Power BI.
HarryBailey I did a video on this long time ago, check it here: Grouping Dimension by Measures in Matrix Visual Power BI: An Illustrative Use of Calculation Groups
