Forum Discussion
One column, multiple data types
Guys, good afternoon.
Would you know a way to format several types of data that are in a single column?
For example, I have a column to insert into a bar chart with the following types: monetary ($), percentage (%) and integers.
I've tried different ways but I haven't been successful, has anyone experienced this situation?
Hello hugo_barbara ,
You can create a calculated column in DAX that formats the values as text based on their type try this for table visual.Formatted Values =
SWITCH(
TRUE(),
'YourTable'[Type] = "Monetary", FORMAT('YourTable'[Value], "$#,##0.00"),
'YourTable'[Type] = "Percentage", FORMAT('YourTable'[Value], "0.00%"),
'YourTable'[Type] = "Integer", FORMAT('YourTable'[Value], "#,##0"),
BLANK())
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!Thank You
Dharmendar S
2 Replies
Hello hugo_barbara ,
You can create a calculated column in DAX that formats the values as text based on their type try this for table visual.Formatted Values =
SWITCH(
TRUE(),
'YourTable'[Type] = "Monetary", FORMAT('YourTable'[Value], "$#,##0.00"),
'YourTable'[Type] = "Percentage", FORMAT('YourTable'[Value], "0.00%"),
'YourTable'[Type] = "Integer", FORMAT('YourTable'[Value], "#,##0"),
BLANK())
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!Thank You
Dharmendar S
thanks for the help!
However, when applying the solution provided, I found that the data had a string type, would there be a way to leave it with a numeric type but with the same format as mentioned above?
