Forum Discussion

Helper I

5 years ago

Solved

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

Anonymous
5 years ago
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.

Helper I

5 years ago

	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
Super User
5 years ago
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
  Helper I
  5 years ago
  Hi Pragati,
  
  I want visual in that format. I have tried matrix. But % change is not coming properly.