One column, multiple data types

[hugo_barbara]

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?

[dharmendars007 · Accepted solution]

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

LinkedIN 

[hugo_barbara]

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?