Forum Discussion
Need Help from a Newbie
Hi Pros,
Im quite new with PBI, need help on the below sheet, need advise how i can do i produce simple line chart with the months at x axis.
| Names | Factor | Timeframe | April | May | June | July | August | September | October | November | December | January | February | March |
| xxx | Revenue | FY20A | 3,121,039 | 2,964,176 | 2,966,623 | 3,437,386 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
| xxx | Revenue | FY19A | 2,852,504 | 3,184,394 | 2,804,148 | 3,349,809 | 3,469,732 | 3,124,760 | 4,387,337 | 3,510,698 | 3,780,065 | 3,153,817 | 2,672,308 | 3,296,310 |
| xxx | Revenue | FY20B | 3,500,229 | 3,500,229 | 3,500,229 | 3,500,229 | 3,500,229 | 3,500,229 | 3,500,229 | 3,500,229 | 3,500,229 | 3,500,229 | 3,500,229 | 3,500,229 |
| xxx | GP | FY20A | 353,033 | 402,879 | 432,503 | 630,971 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
| xxx | GP | FY19A | 830,703 | 1,269,135 | 889,728 | 1,308,176 | 1,370,710 | 1,017,163 | 2,090,567 | 1,001,755 | 1,420,775 | 1,034,724 | 759,713 | 1,237,861 |
| xxx | GP | FY20B | 1,326,479 | 1,326,479 | 1,326,479 | 1,326,479 | 1,326,479 | 1,326,479 | 1,326,479 | 1,326,479 | 1,326,479 | 1,326,479 | 1,326,479 | 1,326,479 |
| xxx | GP | FY20A(Margin) | 11% | 14% | 15% | 18% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
| xxx | GP | FY19A | 29% | 40% | 32% | 39% | 40% | 33% | 48% | 29% | 38% | 33% | 28% | 38% |
| xxx | GP | FY20B | 38% | 38% | 38% | 38% | 38% | 38% | 38% | 38% | 38% | 38% | 38% | 38% |
| xxx | Admin | FY20A | 375,159 | 289,453 | 310,663 | 233,517 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
| xxx | Admin | FY19A | 214,414 | 185,258 | 159,837 | 167,476 | 166,192 | 160,268 | 172,288 | 207,885 | 216,269 | 242,352 | 150,405 | 677,658 |
| xxx | Admin | FY20B | 252,599 | 252,599 | 252,599 | 252,599 | 252,599 | 252,599 | 252,599 | 252,599 | 252,599 | 252,599 | 252,599 | 252,599 |
| xxx | Admin | Ratio | 12% | 10% | 10% | 7% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
| xxx | PAT | FY20A | 32,260 | 172,456 | 168,886 | 215,894 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
| xxx | PAT | FY19A | 468,349 | 906,907 | 541,059 | 960,200 | 886,352 | 624,767 | 1,399,411 | 600,568 | 870,960 | 555,148 | 459,924 | 397,466 |
| xxx | PAT | FY20B | 810,947 | 810,947 | 810,947 | 810,947 | 810,947 | 810,947 | 810,947 | 810,947 | 810,947 | 810,947 | 810,947 | 810,947 |
Hi Genuiney666,
You will first need to unpivot the data - I would suggest reading this blog post, which covers the concepts of both pivoting and unpivoting using Power Query (M) inside Power BI. Once your months exist in a single column, you'll be able to add to the x-axis.
You will also likely need to sort the months into a sensible order - you can do this with a sort by column in your data model.
I would suggest that if you have reviewed these concepts and still need some specific assistance, then you can post your questions in the Power Query (for transformation) or Desktop (for visualising) forums, as this particlar forum is concerned with developing custom visuals (extensions) to Power BI and does not get a lot of traffic - the other forums are highly-frequented with many more people who can assist, and more quickly than in here.
I hope this gets you on your way. Good luck!
Daniel
To buttress dm-p 's reply, you essentially need to get your columns in the order shown below, which you can achieve by using the PowerQuery Editor and running the 'Unpivot' operation. You can then create column MonthNumber (1 - 12) using DAX to sort the Month column.
Date Year Month Names Factor Timeframe Amount
4 Replies
Hi Genuiney666,
You will first need to unpivot the data - I would suggest reading this blog post, which covers the concepts of both pivoting and unpivoting using Power Query (M) inside Power BI. Once your months exist in a single column, you'll be able to add to the x-axis.
You will also likely need to sort the months into a sensible order - you can do this with a sort by column in your data model.
I would suggest that if you have reviewed these concepts and still need some specific assistance, then you can post your questions in the Power Query (for transformation) or Desktop (for visualising) forums, as this particlar forum is concerned with developing custom visuals (extensions) to Power BI and does not get a lot of traffic - the other forums are highly-frequented with many more people who can assist, and more quickly than in here.
I hope this gets you on your way. Good luck!
Daniel
Thanks. appreciate it.
Hi,
I am afraid that your issue is unclear. Could you please provide more details?
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]To buttress dm-p 's reply, you essentially need to get your columns in the order shown below, which you can achieve by using the PowerQuery Editor and running the 'Unpivot' operation. You can then create column MonthNumber (1 - 12) using DAX to sort the Month column.
Date Year Month Names Factor Timeframe Amount
