Forum Discussion
Recommended Power BI dataset layout?
Hi. Pls advise if there is any "best" layout for Power BI dataset? Should I organise the data horizontally (example A) or vertically (example B)? Does it have any implication if I want to create a profit & loss statement (showing actual, budget, prior and variance comparisons in separate columns) by way of Matrix table?
Example A:
| Country | Month | Version | Sales | Gross margin | Net profit |
| A | Jan | Prior Year | 100 | 70 | 40 |
| A | Jan | Budget | |||
| A | Jan | Actual | |||
| A | Feb | Prior Year | |||
| A | Feb | Budget | |||
| A | Feb | Actual |
Example B:
| Country | Period | Version | Line | Value |
| A | Jan | Prior Year | Net Sales | 100 |
| A | Jan | Budget | Net Sales | |
| A | Jan | Actual | Net Sales | |
| A | Jan | Prior Year | Gross margin | |
| A | Jan | Budget | Gross Margin | |
| A | Jan | Actual | Gross Margin | |
| A |
1 Reply
- vivran22
Community Champion
Anonymous
Hi,
In my experience, I would prefer to go with "Example A" as it will help me in creating visuals for the KPIs Sales/Gross Margin/Net Profit by simple drag drop and can use the columns "Country/Month/Version" as filter/slicer.
Thanks,
Vivek
