Dynamically formatting the number when a filter is implemented

[Anonymous]

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.

[v-zhangti · Accepted solution]

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.

[amitchandak]

@Anonymous , refer to the old solution on same topic

https://community.powerbi.com/t5/Desktop/Format-currency-to-millions-and-thousands-symbol-based-on-the/m-p/623856