topic Re: Need Help from a Newbie in Custom Visuals Development Discussion

Need Help from a Newbie

Genuiney666 — Thu, 29 Aug 2019 09:09:38 GMT

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

Re: Need Help from a Newbie

v-evelk — Mon, 02 Sep 2019 15:18:32 GMT

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

Re: Need Help from a Newbie

dm-p — Mon, 02 Sep 2019 19:31:17 GMT

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

Re: Need Help from a Newbie

Genuiney666 — Tue, 03 Sep 2019 06:39:59 GMT

Thanks. appreciate it.

Re: Need Help from a Newbie

Servus — Wed, 04 Sep 2019 00:42:47 GMT

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