Switching between Absolute and % view problems

[rpinxt]

So I made a calculation group in tabular editor in order for me to switch between absolute view and percentage view with a slicer.

Works like a charm however have some formatting issues.

This is % view:

Looks fine.

However my Absolute numbers:

This is not what we want. So just change the view to thousands you would say.

Indeed works like a charm for my absolutes:

See...just fine. But guess you guys feel this one coming...my percentages:

This is not good. Is there something that I can do to get around this problem?

Maybe a setting or something in Tabular Editor or something else??

[johnt75 · Accepted solution]

You could use a field parameter instead of a calculation group, I'm pretty sure that swaps out the axis values as well.

[rpinxt]

Thanks @johnt75 only learned about this new option today!! 😁

This indeed will make things a lot easier.