Adding measures to a matrix

[m5edward]

Hi Everyone,

I am currently making a daily store sales table and am having trouble adding 2 measures that I created (previous week's sales and % change).

The issue I am having is when I drop the 2 measures into my matrix, the format changes to something completely unusable. See below.

Also, I want all 7 days to show even if they are not complete. Example: Today is Monday, so I only have Sunday's sales, but I still want Monday-Saturday to show at the top, and all figures Monday-Friday should be blank or "-".

Desired Result

Before

After

 

[ExceLoki]

2 questions:
1- what version of excel are you using?
2- do you have a sample that you can share (preferably using xl2bb) so we don have to recreate the sheet you're using?
---can change any sensitive data

 

[m5edward]

2 questions:
1- what version of excel are you using?
2- do you have a sample that you can share (preferably using xl2bb) so we don have to recreate the sheet you're using?
---can change any sensitive data

This is actually in Power BI. That said, I figured it out but I'll give you credit for the answer.

 

[Fluff]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[m5edward]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

Sorry about that. I'll post the solution.

 

[m5edward]

Solution

Under formatting, go Values -> Options and make sure that 'Switch values to rows' is off.