The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
hi
I have no idea how to create a dashboard with dates in columns. I have a demand by SKus per week, into the file my dates are located in the column and rows with the number.
I need a line chart or clustered column chart showing the demand per week. X axis the dates or weeks and Y axis the demand.
10/30/2018 | 11/6/2018 | 11/13/2018 | 11/20/2018 |
9 | 40 | 40 | 60 |
288 | 510.02976 | 144.0004 | 468.17752 |
18 | 84 | 12 | 60 |
40 | 160 | 24 | 120 |
12 | 3 | 15 | 69 |
103 | 243 | 139 | 229 |
I have problems to modelling this graphic.
thanks for your help
Solved! Go to Solution.
Hi @Anonymous,
Select all columns and unpivot.
Place [date] onto Axis and [demand] in Value.
Best regards,
Yuliana Gu
Hi @Anonymous,
Select all columns and unpivot.
Place [date] onto Axis and [demand] in Value.
Best regards,
Yuliana Gu
Hi @Anonymous
This table structure won't work because the columns seem to have different datatypes. Either that or the data is unpivoted.
Could you provide a more structured data (maybe use Excel), along with the column names, so that it becomes easier for us to identify the problem?
thanks for your time, it was suggested to unpivot the columns.
appreciated your support
great help appreciated your help, now fix it for me
regards
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
79 | |
71 | |
48 | |
41 |
User | Count |
---|---|
138 | |
108 | |
71 | |
64 | |
58 |