topic One column, multiple data types in DAX Commands and Tips

One column, multiple data types

hugo_barbara — Wed, 11 Dec 2024 16:42:52 GMT

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?

Re: One column, multiple data types

dharmendars007 — Wed, 11 Dec 2024 17:22:18 GMT

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

Re: One column, multiple data types

hugo_barbara — Thu, 12 Dec 2024 11:59:18 GMT

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?