Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In the following table as example :
Table1
column |
-1,14 |
-0,07 |
0,67 |
1,00 |
-2,77 |
which format string should be used to get this result:
column |
-1,14% |
-0,07% |
0,67% |
1,00% |
-2,77% |
(',' is for decimal number -2,77 =-2.77)
I know there are other ways in tabular to do this but I should do this with Format function.
One solution is to change the column to percentage directly from DATA >>Column Tools >> Formatting.
you can also format your column using DAX
Column = FORMAT(DIVIDE(Sheet1[Profit],10000),"percent")
And if you want to convert "," to "." then use the following DAX, and to convert it into percentage use the above steps.
column = SUBSTITUTE(Sheet1[Profit],",",".")
@Anonymous
In our example both numbers have "," Do you need to convert to "," or "."
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I need to convert to ','(as example shows) . I only wanted to be clear 🙂
@Anonymous
Not quite clear about what you are trying to do but add the following column to convert :
Column = SUBSTITUTE(SUBSTITUTE(Table2[Column1],",","."),"%","") /100
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy I get this:
As I mentioned I want to use Format function with a string of # and 0. I've tested different type of string like "#0,00%" (it's just an example) but don't get what I want.
I am still confused about the what you exactly need. Your locale is different from mine too.
refert to: https://dax.guide/format/
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |