Forum Discussion

ERing's avatar
ERing
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Format String to remove decimal places?

I was recently provided a solution here to allow for grouped headers in my matrix visual. The solution uses a disconnected table with a Format String column and a SWITCH. The measure format propertie...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    ERing 

     

    you need to select the dynamic and add DAX coding


    SWITCH(
        SELECTEDVALUE('Table'[type]),
        "actual","0.0",
        "py","0"
        )
     
  • danextian's avatar
    danextian
    1 year ago


    This is from your previous sample file, and you can see that the format strings are applied correctly. So, it’s likely that something in your current file—such as settings or other factors—is preventing the format strings from being applied properly.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ERing,

 

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

 

Best,

Prasanna Kumar