Forum Discussion
Solved
Data formatting issue
Quick question but I have a feeling it might not be possible. I am using an excel source document with columns. One column holds the data. The other columns are for filtering purposes. The data ...
Hello EmilieRuff
USE DAX for dynamic formatting
Formatted Value =
IF(
SELECTEDVALUE('Table'[Type]) = "Percentage",
FORMAT([Value], "0.00%"),
FORMAT([Value], "0.00")
)
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedIn
Hello EmilieRuff
USE DAX for dynamic formatting
Formatted Value =
IF(
SELECTEDVALUE('Table'[Type]) = "Percentage",
FORMAT([Value], "0.00%"),
FORMAT([Value], "0.00")
)
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
Thank you for your suggestion. I will look into it.
