Two Y axis values in Column Chart

[Ashley]

Hello,

I currently have a column chart that shows total inventory of products at a specific location. It is built for the user to select multiple SKUs to compare them against eachother to see how they are moving. I want to add the price for each product in the chart as well, however when I convert it to a clustered column and line chart nothing shows up for price unless I choose one product only (which defeats the purpose of functionality for this chart). And the price shown isn't even correct. You'll see below the price axis value shows roughly $49 but the product is actually $39. 

Is there a way to show both price and inventory value without using a combo chart? What am I missing here? Any help would be greatly appreciated.

Thank you,

Ashley

[Mayank_Yavda · Accepted solution]

Hi @Ashley 

Here is Line and clustered column chart With Custom Tooltip which will help you to get line visual with clustered chart and you can use legend on line also. Hope this helps you.

Line and clustered Column Chart with custom tooltip PBIVizEdit.comLine and clustered Column Chart with custom tooltip PBIVizEdit.com

Download link for the custom visual file in this page

https://pbivizedit.com/gallery/line-and-clustered-column-with-custom-tooltip 

Youtube Link for the custom visual

https://www.youtube.com/watch?v=hJLbVBt9ne8 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

• anyone, irrespective of technical skills, can create their own visuals
• 15 minutes to create a visual from scratch
• opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

Thanks,
Team PBIVizEdit

[amitchandak]

@Ashley , You can have only one line in clustered line visual, it will not add a line for each legend value. If that was the need