Slicer and DAX formula to show data in 1s, 10s, 100s, 1000s, millions etc


#1

Is there a way to add a slicer and DAX formula where I can select whether to show data in ones, tens, hundreds, thousands etc?
Working with data that on a monthly time frame it is best to display in 1s or up to thousands but on a yearly time frame best to display in millions etc.
Thanks.


#2

Yes you definitely can, and it’s actually quite simple.

All you need to do is create a quick fire table, with the 1/10/100/1000

Then use SELECTEDVALUE function to calculate what you might be selecting in the slicer.

Then you have you denominator to use in your other measures.

If you want to change it based on a different context, then you’ll need to also use the ISFILTERED function somewhere in your logic.

Chrs


#3

Awesome. Thanks.