Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
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
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)
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
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
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
2 | |
2 | |
1 | |
1 |