only show decimal point when there is a value after 10k

[Anonymous]

Hi Team,

I wanted to show one decimal point if the Sales value exceeds 10,000 for example 10.5K if it is less than 10,000 then it should value without decimal point for example 9023

I can't use Format function as that would convert the measure to Text and i can't use that text measure in bar chart.

Could you please help me on this ?

Thanks,

Shubham

[amitchandak]

@Anonymous , You can try like and set decimal format to auto

sumx(Table, if([sales]<10000, round([sales],0) , round([sales],2)))

But I doubt this will work because internally it might still have a fixed decimal places.