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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
ElliotG
Frequent Visitor

How To Have Y Axis Label Match Length Between 2 Graphs so X Axis Stays The Same?

Hi Everyone,

Do you know a way to have the label on the left side of the graph between the 2 graphs always have the same length? 


For example, with image A, I have selected a value of A.  When I change the slicer on the page, in Image B, the bottom graph doesn't change (as it's not impacted by the slicer interaction), but the top graph does change and then the two graphs don't align.  It would be great if they both aligned on the X-Axis no matter what the slicer selected!

Image A:

ElliotG_0-1706281156906.png

 

Image B:

ElliotG_1-1706281185804.png

 

 

1 ACCEPTED SOLUTION
qqqqqwwwweeerrr
Super User
Super User

Hi @ElliotG 

 

With the current capabilities, it is not possible and I do not find this kind of option available on Power BI but here i have done some work around the to make it more better vissually 

 

Here are steps you need to follow but make sure you should have latest version of power bi 

1. Create Dummy measure with value 0 (

Dummy = 0)
2. create one more measure 
Measure = SELECTEDVALUE(Sheet2[event_name])
3. now crea the dsried visual bar chart 
qqqqqwwwweeerrr_0-1706358946141.png

add the first measure here 
I format pane:

first select the Data Lables> series select dummy 

qqqqqwwwweeerrr_1-1706359153478.png

Go to Detail section and add Measure you have created in data section 
by doing this your visual should look like this 

qqqqqwwwweeerrr_2-1706359240060.png
 
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem


Regards

View solution in original post

3 REPLIES 3
qqqqqwwwweeerrr
Super User
Super User

Hi @ElliotG 

 

With the current capabilities, it is not possible and I do not find this kind of option available on Power BI but here i have done some work around the to make it more better vissually 

 

Here are steps you need to follow but make sure you should have latest version of power bi 

1. Create Dummy measure with value 0 (

Dummy = 0)
2. create one more measure 
Measure = SELECTEDVALUE(Sheet2[event_name])
3. now crea the dsried visual bar chart 
qqqqqwwwweeerrr_0-1706358946141.png

add the first measure here 
I format pane:

first select the Data Lables> series select dummy 

qqqqqwwwweeerrr_1-1706359153478.png

Go to Detail section and add Measure you have created in data section 
by doing this your visual should look like this 

qqqqqwwwweeerrr_2-1706359240060.png
 
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem


Regards

Hi, thanks for the suggestion!  I have tried your steps but I don't have the label showing on top of the bars.  I am using the Stacked Bar Chart and the label is showing inside the bar.  I can't find a way to have it above like yours is

Hi @ElliotG 

 

the chart images you have shared i belive that are cluster bar chart correct not stacked chart, if not can you share the required stack chart with expected image, secondly are you using latest verison of power bi since what i have done is on lasted version please check that as well 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

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.