Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!!!
Solved! Go to 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
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
User | Count |
---|---|
85 | |
76 | |
73 | |
70 | |
57 |
User | Count |
---|---|
98 | |
97 | |
92 | |
78 | |
70 |