Forum Discussion

GregWoolley's avatar
GregWoolley
New Member
2 years ago
Solved

Customise Bar chart axis

Hi all,

 

I would like to control the max value of my y axis on a bar chart in a dashboard. Currently two adjacent bar charts have differing max y axis values of £1M and £2M (auto-generated due to values within the relevant data).

 

Can I control both y-axis so they both have max values of £2M and therefore the scales of the adjacent charts are the same?

 

If so, what would be the most straightforward way please.

 

Thanks, Greg

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi GregWoolley ,

     

    Refer this, for continuous axis tick marks, you cannot control the format string. Power BI chooses the best tick interval based on your data range, and creates a minimal format string for this unit interval, to preserve space.

     

    My test:

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi GregWoolley ,

     

    Refer this, for continuous axis tick marks, you cannot control the format string. Power BI chooses the best tick interval based on your data range, and creates a minimal format string for this unit interval, to preserve space.

     

    My test:

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.