How To Use Fixed Values For Y Axis in Power BI

Power BI Visuals have a floating Y axis, based on the range of values. This may look pretty, but makes it difficult to compare different things.
Fixing the Y axis in a Power BI visualization will allow us to easily compare and see which slice gives a higher result, and which values are low.

An excellent Microsoft Power BI tip that will make sense when you are comparing the sales or revenue of different products, categories, countries, segments or regions. This Power BI tip makes it a real comparison chart that is worth to put in a Dashboard for management, and share it with them.

Similarly,  to visualize percentages, while your graph is selected, click the paintbrush (Format Painter) in the Visualizations pane, and then the drop-down for the Y-axis settings. You should see a Start and End that are currently set to Auto. Set them to 0 and 1, and your Y-axis will be set from 0 to 100%.

You can also Customize x-axis and y-axis properties in the same way.

Works with any version of Power BI.
For more tips and tricks on Power BI, visit https://www.excelchamp.net

And for Power BI Training courses, visit https://www.intellisoft.com.sg & https://www.trainingint.com for government funded WSQ courses which can get up to 70% funding grants.

Learn Power BI tips & Tricks to visualize data better.

Created by Vinai Prakash, Founder of ExcelChamp.Net

• #howto_style
• #power_bi
• #powerbi
• #fixing_y_axis
• #microsoft_power_bi
• #power_bi_tips
• #power_bi_tricks
• #excelchamp
• #vinai_prakash
• #intellisoft_systems
• #customize_y_axis
• #customize_x_axis