help required

[bicoffee]

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

[Anonymous · Accepted solution]

@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.

[bicoffee]

	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%

[Pragati11]

Hi @bicoffee ,

When you say output - do you mean creating a table in this format?

Or you wat to visualise your existing data in this format? If you just want to visualise it this way then try using a matrix visual in Power BI.

Thanks,

Pragati

[bicoffee]

Hi Pragati,

I want visual in that format. I have tried matrix. But % change is not coming properly.