Forum Discussion
Solved
Custom numeric format for column
Hello, inside my report i have numeric measures and columns where i would like to display number in a simplified way. For example: 1.234.346€ i want to see 1,2M€ 12.340€ i want to see 12,3K€ 12...
Hi wep
SELECTEDMEASURE() only works for measures, not for columns in Power BI visuals. If you wanted to use this function on one of your measures for numeric aggregations, i found a good video from Curbal that may help you achieve this.
https://www.youtube.com/watch?v=_F4MwolGrmg
Please let us know if there's a better way.
Thanks
Mason
wep , Try using
FormattedColumn =
SWITCH(
TRUE(),
[YourColumn] >= 1000000, FORMAT([YourColumn], "0.0,,") & "M€",
[YourColumn] >= 1000, FORMAT([YourColumn], "0.0,") & "K€",
FORMAT([YourColumn], "0 €")
)
This is for dynamic format and it applies only to measure.
I cant write that in the box i have posted in the last picture.
