Forum Discussion
Add scale filter (million/thousand)
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
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
4 Replies
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
Vvelarde Thanks !!!
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.
Anonymous
Switch accept more than 2 parameters.
Review this link.
https://msdn.microsoft.com/en-us/query-bi/dax/switch-function-dax
Regards
Victor