Forum Discussion
Sales data across multiple coumns
Hi everyone,
I'm quite new to BI and have hit a problem. I have some sales data that is stored per month, and in Excel this is very easy to graph showing each month's sales as a data point:
| BRAND | JAN | FEB | MAR | APRIL | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |
| Supermetro | $0.00 | $75,832.51 | $96,955.06 | $42,595.11 | $46,712.63 | $80,980.81 | $42,702.35 | $65,021.13 | $106,383.97 | $72,227.73 | $190,173.33 | $80,194.25 |
| Arrowroot | $58,673.00 | $87,508.00 | $65,778.00 | $141,962.00 | $124,863.00 | $180,056.00 | $107,724.00 | $209,075.00 | $72,992.00 | $248,164.00 | $142,690.00 | $200,767.00 |
In Excel this would show as follows:
I'm trying to add this data into Power BI and get a similar result but I'm struggling. I basically want the above visuals but with a brand slicer. The closest I've managed is this:
Can anyone point me in the right direction?
Hi Caluminium,
You will need to model your data in power bi query editor to produce this visual as per your requirement.
You can see below the detailed steps.
Please mark this post as an accepted solution if this helped you.
Regards,
Affan
2 Replies
- affan
Solution Sage
Hi Caluminium,
You will need to model your data in power bi query editor to produce this visual as per your requirement.
You can see below the detailed steps.
Please mark this post as an accepted solution if this helped you.
Regards,
Affan
Amazing - thank you so much for your help!
