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

[Ale]

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

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.

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.

[Ale]

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]

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.