cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Genuiney666
Frequent Visitor

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.

NamesFactorTimeframeAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarch
xxxRevenueFY20A  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
xxxRevenueFY19A  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
xxxRevenueFY20B  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
xxxGPFY20A     353,033     402,879     432,503     630,971#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
xxxGPFY19A     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
xxxGPFY20B  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
xxxGPFY20A(Margin)11%14%15%18%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
xxxGPFY19A29%40%32%39%40%33%48%29%38%33%28%38%
xxxGPFY20B38%38%38%38%38%38%38%38%38%38%38%38%
xxxAdminFY20A     375,159     289,453     310,663     233,517#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
xxxAdminFY19A     214,414     185,258     159,837     167,476     166,192      160,268     172,288     207,885     216,269     242,352     150,405     677,658
xxxAdminFY20B     252,599     252,599     252,599     252,599     252,599      252,599     252,599     252,599     252,599     252,599     252,599     252,599
xxxAdminRatio12%10%10%7%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
xxxPATFY20A       32,260     172,456     168,886     215,894#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
xxxPATFY19A     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
xxxPATFY20B     810,947     810,947     810,947     810,947     810,947      810,947     810,947     810,947     810,947     810,947     810,947     810,947

 

2 ACCEPTED SOLUTIONS
dm-p
Super User I
Super User I

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

Servus
Frequent Visitor

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

View solution in original post

4 REPLIES 4
Servus
Frequent Visitor

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

View solution in original post

dm-p
Super User I
Super User I

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

Genuiney666
Frequent Visitor

Thanks. appreciate it.

v-evelk
Microsoft
Microsoft

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
pbicvsupport@microsoft.com

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors