Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear all ,
I have a measure which returns me value such as
1000
23
3200
2
500000
I want to return
1k
23
3.2k
500k
I tried using format into thousand but it converts all numbers to K format
I want only those numbers to turn in K format which are greater than 1000
Need help
Regards
Sujit
Solved! Go to Solution.
Ok friends
I tried and I reached to conclusion
Loss = var a = MEASURE
RETURN IF(a>=1000,Format(a,"#,.#K"),a)
If you have more optimized solution please feel free to shoot your advices in comments down 👍
@Sujit_Thakur , In model view , you have property. Once you click on a column then you will be able set its property there you can set format -https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
or you can use the format command. Or can mention format in measure/column tools
The above article also contain how to give format string
Ok friends
I tried and I reached to conclusion
Loss = var a = MEASURE
RETURN IF(a>=1000,Format(a,"#,.#K"),a)
If you have more optimized solution please feel free to shoot your advices in comments down 👍
@Sujit_Thakur , Thanks for sharing.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
37 | |
21 | |
18 | |
15 |
User | Count |
---|---|
125 | |
32 | |
27 | |
24 | |
23 |