Forum Discussion

EmilieRuff's avatar
EmilieRuff
New Member
9 months ago
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 ...
Need Help
Tips and Tricks
  • pankajnamekar25's avatar
    pankajnamekar25
    9 months ago

    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

     

WishAskedSooner's avatar
WishAskedSooner
Continued Contributor
9 months ago

I am not sure I would really recommend this over separating your data, but you could add a conditional format in a measure and use that in your chart e.g.

 

MyMeasure = IF( 'MyTable'[Attribute] = SomeValue, FORMAT( 'MyTable'[Value], "0.00" ), FORMAT( 'MyTable'[Value], "0%" ) )

EmilieRuff's avatar
EmilieRuff
New Member
9 months ago

Thank you for your suggestion. I think this is the direction I will investigate.