Stacked column chart with 2 measures with very different scale

[Anonymous]

Hi All!

I wonder if is possible create a stacked column chart with one measure in % and another measure in $, with a very different scale (for example 5% and $180 Milions), and that despite the great difference between values, the color of the percentage measure is shown as in the screenshot:

I hope I have explained myself.

Thanks a lot!

[amitchandak]

@Anonymous , check one of these can help

Dynamic Label
https://www.esbrina-ba.com/time-intelligence-dynamic-legend-in-line-charts/

Custom label
https://www.youtube.com/watch?v=IH4bcHhxunw

[Anonymous]

Hello,

I will always need to show the two columns, my problem is that the green one is not visible because it is a small percentage (7%) with respect to the blue column, which is a very high value (18 million). Is it possible to show the color of the two columns even though the value is so small? Because the value of the green is so small, it is lost and is not displayed.

Thanks.