Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
rohit_returaj
New Member

How to format Y axis dynamically?

I have created a visual with multiple KPI. Few KPI should display values in numbers while few KPI's should display values in Percentage and few in decimals. How do I make the Y axis dynamic so that the it gets formatted automatically based on the KPI selected on the filter. Like when it is selected number of units sold, Y axis should show only numbers while then share of a product is selcted, Y axis should show percentage. The chart is of single axis and not dual axis.

4 REPLIES 4
rohit_returaj
New Member

Not possible. I have given option to select only one KPI at a time.

techies
Solution Sage
Solution Sage

Hi @rohit_returaj have you tried using calculation groups?

― Power BI | Microsoft Fabric | PL-300 | DP-600 | Blog: medium.com/@cseprs_54978

No, what is that ?

lbendlin
Super User
Super User

What should happen when both "units sold"  and "share of product"  are selected?

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors