To show growth % fiscal year wise

[RohiniP-26]

Hi All,

I need to show growth % (measure) in the above chart.

I have shown sale quantity, gross margin, net margin, net profit fiscal year wise. I have used clustered column chart here.

If I add growth % measure, I cannot use Fiscal Year as a Legend. 

Also I tried Growth rate combo chart, in that chart there is no legend option. So, I cannot split bars by Fiscal year.

I have already calculated growth% , want show like below picture.

Is there any way to show like this ?

Thanks

[RohiniP-26 · Accepted solution]

submitted an idea in Power BI Ideas.

vote up to get this feature quickly.

https://ideas.powerbi.com/ideas/idea/?ideaid=ceb818bc-1870-eb11-8fed-281878bda47d

[amitchandak]

@RohiniP-26 , As growth %, has been created a new measure I doubt you can show them with a legend. But show growth % as a line in clustered bar visual , that should work

[RohiniP-26]

Yes.. I too tried that. But unfortunately Growth % is not splitted by fiscal year. It shows combied growth%.

[amitchandak]

@RohiniP-26 , yes, That will not split. I thought you have only two years, In that only it would have worked.

Check for custom visual https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

Create an idea - https://ideas.powerbi.com/ideas/