Multiple charts (almost trellis) sharing y axis but differing x axis

[Anonymous]

Hi,

I am looking to see if anyone can help us do the below. The graphs have a shared y axis but the important thing here is that they have their own x. i.e. number of suppliers, then spend, then number of invoices etc. 

Lots of the trellis options won't work as it seems like they need to have the same x and y across all charts. I have also tried using conditional formatting on a matrix but this wond show x axis and also won't allow a legend on the bars.

Any help appreciated!

[Anonymous · Accepted solution]

Just to update this, the charts ended up custom charts. 

[Anonymous]

Thanks @amitchandak - I will do that. 

Does anyone know if any of the appsource visuals would help? I've been through quite a few without luck.. Am I missing something? 

[amitchandak]

@Anonymous , Multi-axis chart is not possible with standard visual - You can vote for Idea's

Line and Bar chart with Multiple Axis
https://ideas.powerbi.com/ideas/idea/?ideaid=cc9b1531-8ca4-48be-8035-b6dfc17af84f
https://ideas.powerbi.com/ideas/idea/?ideaid=aec20fda-edc4-466c-a9c0-2772011f6193

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