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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Ale
Resolver II
Resolver II

Small multiple with different Y-Axis formats (not scale)

I'm trying to build a Small Multiple chart just like this one:

 

Ale_0-1708336132475.png

As you can see in the image, each Y-Axis has its own format (absolute number or percentage).

 

I managed to get everything working just fine except that Y-Axis format. In my example, all charts keep the same Y-Axis format, depending on the Measure format. Either decimal or percentage, but not dynamically based on the original measures.

 

Ale_1-1708336246183.png

 

Is there any way to achieve that? My [KPI Value] measure is a SWITCH() function which then returns the value of each measure based on the KPI name. The original measures formats are adjusted accordingly (absolute and percentages), but the [KPI Value] measure overrides their formats.

2 REPLIES 2
Ale
Resolver II
Resolver II

Thanks for the reply @Anonymous ,

 

I tried to split it in 2 measures, one of them as Absolute and the other as Percentage, and added them to the visual. However, the Small Multiples chart only takes the format of the first one. So, the issue remains there.

Anonymous
Not applicable

Hi @Ale ,

My suggestion is create separate metrics for formatting: Instead of relying on a single [KPI Value] metric to dynamically return values in different formats, consider creating separate metrics for each format type (e.g., one metric for absolute numbers and another for percentages). This method allows you to explicitly set the format of each metric based on its intended representation.

Best Regards,

Xianda Tang

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors