Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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.