Forum Discussion

HarryBailey's avatar
HarryBailey
Helper II
6 years ago

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 2...
Need Help
Pragati11's avatar
Pragati11
Super User
6 years ago

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's avatar
HarryBailey
Helper II
6 years ago

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's avatar
    V-lianl-msft
    Community Support
    6 years ago

    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.