Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamically formatting the number when a filter is implemented

Hi everyone, 

 

I have a measure which it's let's say the sales amount and a filter with all the shops in a country and i represent the sales amount in a measure.  The value formatting within the Data label is in thousands so when i have fitered all the shops the number looks ok e.g "20k" but when i filtered a shop for example the value could be 150 or even 50 so i see "0.0k" in the second case. 

Is there a way to make the measure dynamically change so when i select a shop and the number is in hundreds to see a 3 digit number and when is less than 100 to see to digits ?

 

Thanks.

General Comment
Need Help
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    What view are you using to display the results? In Card view, when you set the value format to Auto, it enables automatic switching.

     

    Does this match your desired outcome? If not, please advise what view you expect the output to be in?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more.

2 Replies