Display Forecast and Effective Sales of Products

[Ziller]

Hello!

I´m having a issue to find a better way to display a report on Power BI...

Trying to explain: I have two main channels, that are "At Store" and "Internet", where my company sells 4 different products (A, B, C and D), on also four different stores (A, B, C and D too).

I´d like to have, monthly-base, both forecast and effective sales, in a report like the one below:

I already know that Power BI cannot accept merged cells when importing from excel, so I´ve treated my spreadsheet in a way every cell is filled. But the report is not very good to be used, once that there is a lot of repeated info, like below:

Channel	Product	Store	For./Effect.	jan/22	fev/22	mar/22
At Store	Product A	Store A	Forecast	1959	1975	1170
At Store	Product A	Store A	Effective	735	663	746
At Store	Product A	Store B	Forecast	1772	1355	1376
At Store	Product A	Store B	Effective	679	656	742
At Store	Product A	Store C	Forecast	1159	1995	1429
At Store	Product A	Store C	Effective	256	253	263
At Store	Product B	Store B	Forecast	795	789	788
At Store	Product B	Store B	Effective	1959	1838	1296
At Store	Product B	Store C	Forecast	225	281	245
At Store	Product B	Store C	Effective	616	753	782
Internet	Product C	Store A	Forecast	1641	1115	1861
Internet	Product C	Store A	Effective	263	298	247
Internet	Product C	Store B	Forecast	281	235	264
Internet	Product C	Store B	Effective	1904	1083	1451
Internet	Product C	Store D	Forecast	648	784	752
Internet	Product C	Store D	Effective	277	296	208
Internet	Product D	Store B	Forecast	1516	1072	1894
Internet	Product D	Store B	Effective	280	231	278
Internet	Product D	Store D	Forecast	752	702	668
Internet	Product D	Store D	Effective	1917	1129	1716

Can someone help me improving my reports?

Thanks in advance!!!

[v-easonf-msft · Accepted solution]

Hi, @Ziller 

In Power BI, you can consider using matrix visual to display your data. (Option "Ladder Layout" needs to be turned off)

Best Regards,
Community Support Team _ Eason