0

Use the same Scale on Y axis and Secondary axis

How can I use the same scale in a chart?

 

12 replies

null
    • Redeemed from the Dark Side (Power BI)
    • Obee1
    • 3 days ago
    • Reported - view

    The point of a secondary axis is that it has its own scale. If you don't want a different scale, put both measures on the primary axis. 

      • Pedro.1
      • 3 days ago
      • Reported - view

       If i do that creates 2 charts in the same chart :-( 

       

      • Lead Consultant Advanced Analytics
      • Michael_Daun
      • 3 days ago
      • Reported - view

      , to fix this:

      1. Delete the "Values" chip from the "Trellis" dropzone. As an effect one of your two measure chips in the "Values" drop zone will disappear.
      2. Drag the measure chip which just disappeared, move it to the three points right of the "Values" drop zone and choose "Primary axis" in the pop up. 

      Hope this helps!
      Micha

      • Pedro.1
      • 3 days ago
      • Reported - view

       after point 1 

       after point 2

       :-(

      • Redeemed from the Dark Side (Power BI)
      • Obee1
      • 3 days ago
      • Reported - view

       

      • Pedro.1
      • 3 days ago
      • Reported - view

       Done! :-)

      • Pedro.1
      • 3 days ago
      • Reported - view

       its possible to show days with no data? 

    • Hillel_Dor.3
    • 3 days ago
    • Reported - view

    Hi ,

     

    Adding to the good answers you received from our members, I'll refer you to our Help page which explains how to use such Combo Charts.

      • Pedro.1
      • 3 days ago
      • Reported - view

       The link you shared doesnt have the solution for my issue... i want the same scale 

       

      Thank you!!!

      • Lead Consultant Advanced Analytics
      • Michael_Daun
      • 3 days ago
      • Reported - view

      , read on - just a little bit further... 😉

      • Lead Consultant Advanced Analytics
      • Michael_Daun
      • 3 days ago
      • Reported - view

      Oops, I obviously was a little late, sorry!
      At first, I hadn't seen the posts from the meantime.🙈

      • Hillel_Dor.3
      • 3 days ago
      • Reported - view

       The Y-axis scale is automatically set to be above the Max value of the measure/s on it. If you want both sides (Y1 & Y2) to have exact same scale range you can manually set it for both through the Formatting Panel

       https://help.pyramidanalytics.com/2025/Content/Root/MainClient/apps/Discover/PRO/Formatting%20and%20Design/FormattingPanel/Axes.htm?Highlight=scale%20bounds

Content aside

  • 3 days agoLast active
  • 12Replies
  • 135Views
  • 4 Following