Columns and Values in Matrix - reverse order

[HarryBailey]

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.

[Anonymous]

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

[Pragati11]

Hi @HarryBailey ,

To achieve something similar to as per your 2nd screenshot, you will need a column in your data which has 2 values:

1. Sales
2. 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

[HarryBailey]

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?

[V-lianl-msft]

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.

[Greg_Deckler]

Should be able to use a disconnected table trick for that. Here is an example:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/td-p...