Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
I have this table that have a column woth different data type (currency, percentage, date, etc.). How to format this column in power bi?
The tables is the follwing:
Teste Data Type
250 Currency
0,05 Percentage
15 -11-2022 Date
Thank you for your help.
Best regards.
Joaquim Guedes
Solved! Go to Solution.
Hi, @Joaquim_Guedes ;
Yes, a column can only set one number type, if you want the display to be different, you can use the format function in dax. Like what:
Column =
var _num=CONVERT([Teste ],DOUBLE)
return
IF(CONTAINSSTRING([Teste ],"-")=FALSE(),
IF( _num<1,FORMAT(_num,"0.00%"),FORMAT(_num,"Currency")),
[Teste ])
The final show:
however this column is text type, if you want convert to number or percent,you could create a measure by If().
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Joaquim_Guedes ;
Yes, a column can only set one number type, if you want the display to be different, you can use the format function in dax. Like what:
Column =
var _num=CONVERT([Teste ],DOUBLE)
return
IF(CONTAINSSTRING([Teste ],"-")=FALSE(),
IF( _num<1,FORMAT(_num,"0.00%"),FORMAT(_num,"Currency")),
[Teste ])
The final show:
however this column is text type, if you want convert to number or percent,you could create a measure by If().
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have multiples tables, with multiple columns. How can I transform the following table
Table 1
Kpi Value
Kpi 1 0,35
Kpi2 44860
Kpi3 150
Kpi4 1050
to this table
Table 2
Kpi Value
Kpi1 35%
Kpi2 26-10-2022
Kpi3 150,00€
Kpi4 1.050,00
Do I have to create a measure or a column to solve this problem? I have mutiple tables and columns with this situation. I can't chage data format in the data source files. Thank for your help.
Beste regards.
Joaquim Guedes
Hello!
Thank you very much for your help!
That solution solves the problem, but I have another situation to solve. If i have a in the Teste column a number to transform in date format? How to turn the problem around? Thank you for the help.
Best regards.
Joaquim Guedes
Hello @AntrikshSharma!I have multiple indicators in a table and each indicator has different data type!
Ok, but you can't have multiple data types in a single column, it will work in PowerQuery, but once loaded in the data model it will be text in your case.