Forum Discussion

Yonko's avatar
Yonko
Helper I
3 years ago
Solved

Using Format function with Calculated Groups to convert numbers to millions doesn't work properly

Hello. I have some data with big numbers and what i want is to create a slicer so a user can choose what format he want to see: usual (like 1 234 567) or in millions (1.2 M). To make this i created a...
  • johnt75's avatar
    3 years ago

    Change the calculation item for the millions. Change the expression to just return SELECTEDMEASURE(), as the other one does, and instead edit the format string expression for the millions.