Forum Discussion

ElliotG's avatar
ElliotG
Frequent Visitor
2 years ago
Solved

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:

 

Image B:

 

 

Need Help
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    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 

    add the first measure here 
    I format pane:

    first select the Data Lables> series select dummy 

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

     
    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

3 Replies

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Solution Sage
    2 years ago

    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 

    add the first measure here 
    I format pane:

    first select the Data Lables> series select dummy 

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

     
    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
    • ElliotG's avatar
      ElliotG
      Frequent Visitor
      2 years ago

      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

      • qqqqqwwwweeerrr's avatar
        qqqqqwwwweeerrr
        Solution Sage
        2 years ago

        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