Add scale filter (million/thousand)

[Anonymous]

Hi,

Is it possible to create a slicer that can filter through millions and thousands? I divide my metrics by millions and thousands, only now I do not know how I can make this slicer or another way for the user to choose what they want to see values in millions or thousands.

Best regards

[Vvelarde · Accepted solution]

@Anonymous

Hi, you can create a disconnected table with this 2 rows : MIlions and Thousands and use it in a slicer.

And can you use this measure

Measure =
SWITCH (
    SELECTEDVALUE ( Units[Metric Unit] ),
    "Millions", DIVIDE ( SUM ( Table1[Value] ), 1000000 ),
    "Thousands", DIVIDE ( SUM ( Table1[Value] ), 1000 )
)

Regards

Victor

[Anonymous]

@Vvelarde

Hi, sorry to bother, but it is possible to add one more field. I want "A" as absolute value, "K" as thousands and "M" as millions. The Switch function only accepts two parameters

Best regards. 

[Vvelarde]

@Anonymous

Switch accept more than 2 parameters.

Review this link.

https://msdn.microsoft.com/en-us/query-bi/dax/switch-function-dax

Regards

Victor

[Anonymous]

@Vvelarde Thanks !!!