Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Super User

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
dm-p
Super User
Super User

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)




Thanks. appreciate it.

v-evelk
Employee
Employee

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors