Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ashley
Helper II
Helper II

Two Y axis values in Column Chart

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. 

 

Ashley_0-1644964863706.png

Ashley_1-1644964982492.png

 

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

 

 

1 ACCEPTED SOLUTION
Mayank_Yavda
Resolver II
Resolver II

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.comLine 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

View solution in original post

2 REPLIES 2
Mayank_Yavda
Resolver II
Resolver II

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.comLine 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
Super User
Super User

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.