Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
Hi @HarryBailey ,
To achieve something similar to as per your 2nd screenshot, you will need a column in your data which has 2 values:
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.
Should be able to use a disconnected table trick for that. Here is an example:
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |