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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
dkernen2
Helper II
Helper II

Side by Side Bar Chart - Using Deneb - Using a common Y axis

I have created an HCONCAT in Deneb of two bar charts, but I need them to utilize the same Y axis.  The bar charts should use measures.  I'd like to be able to have the same axis so that it could be sorted, and both charts would sort the same.  It's possible that some of the categories could have null values for one of the measures, which is why it's important that they share the same axis.  I've tried to bring the y encoding out of the layers/facets but I've not found the solution.  

I have created a small sample dataset.  https://kauffman.box.com/s/4dble8w64y9nfeakpirsyjnrs1ogehe7  Does anyone have any tips to make this possible?  Thank you in advance!

@giammariam @deneb@sidebyside

1 ACCEPTED SOLUTION
giammariam
Super User
Super User

Hey @dkernen2, thank you for the .pbix, all the detailed info, and the tag. Let me know if this is what you're after: 

Changes: 



Madison Giammaria
Proud to be a Super User 😄
LinkedIn

Do you frequently use Deneb to provide insights to your stakeholders? Have you considered sponsoring this free and open source custom visual? More info here!

View solution in original post

3 REPLIES 3
dkernen2
Helper II
Helper II

Hi @giammariam I've tried to change the height to be variable, so that the bars fill the allotted space, but they remain a fixed height.  I've tried to put a height declaration in "spec" as well as the "height" overall, but I cannot seem to get anything to work.  Where can I make the height so that I either it is dynamic with however side the user uses in the GUI OR set it to a fixed size and then use a formula so that the bar height relates to the number of categories?  Do you have any ideas?  You appear to be superhuman in your VegaLite!

https://kauffman.box.com/s/3ypt201mq20hmycva1g3jn28ugw1bre7  Report: SideBySideBarSharedY

dkernen2
Helper II
Helper II

Glorious - and brilliant!  Thank you @giammariam !!!!

giammariam
Super User
Super User

Hey @dkernen2, thank you for the .pbix, all the detailed info, and the tag. Let me know if this is what you're after: 

Changes: 



Madison Giammaria
Proud to be a Super User 😄
LinkedIn

Do you frequently use Deneb to provide insights to your stakeholders? Have you considered sponsoring this free and open source custom visual? More info here!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

Top Solution Authors
Top Kudoed Authors