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
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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.