Can I show two different units on a stacked bar chart?

[Anmolgan]

Hi I am trying to build a visual with drill down approach, it should work like, the first level should show me dollar units and when I drill further down it should show me % value in the data value options? IS it possible with powerbi? if yes then can someone share any examples how this can be done?

[v-yingjl]

Hi @Anmolgan ,

I'm afraid not. As we know, drill up and drill down are based on a hierarchy to work, you may not use different units to show the same hierarchy when drilling up and down. It is a hierarchy relationship in one field not between two units.

Best Regards,

Yingjie Li

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