Forum Discussion
One column, multiple data types
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
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?