Forum Discussion
help required
Hi require help to get the output of my data in the following format.
| APRIL | MAY | JUNE | |||||||
| OUTLET | Sales 2020 | Sales 2021 | % change | Sales 2020 | Sales 2021 | % change | Sales 2020 | Sales 2021 | % change |
| O1 | 1050 | 2000 | 48% | 4000 | 5000 | 20% | |||
| O2 | 200 | 1000 | 80% | 4000 | 3500 | -14% |
my data structure is as below
| DATE | OUTLET | SALES |
| 2020-04-01 | O1 | 1050 |
| 2020-04-02 | O2 | 200 |
| 2020-04-03 | O3 | 3000 |
| 2020-05-04 | O1 | 4000 |
| 2020-05-04 | O2 | 4000 |
| 2020-05-04 | O3 | 6000 |
| 2021-04-01 | O1 | 2000 |
| 2021-04-02 | O2 | 1000 |
| 2021-04-03 | O3 | 3500 |
| 2021-05-04 | O1 | 5000 |
| 2021-05-04 | O2 | 3000 |
| 2021-05-04 | O3 | 7000 |
bicoffee
This had been a known issue, you cannot make power bi matrix display in the way you are expecting as you can only have 1 row as the header. Instead, you may create a matrix like the following:Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
4 Replies
April May OUTLET sales 2020 sales 2021 % change sales 2020 sales 2021 % change O1 1050 200 48% 4000 5000 20% O2 200 1000 80% 4000 3500 -14% Hi Pragati,
I want visual in that format. I have tried matrix. But % change is not coming properly.
bicoffee
This had been a known issue, you cannot make power bi matrix display in the way you are expecting as you can only have 1 row as the header. Instead, you may create a matrix like the following:Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
