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.

     

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

Hi danextian

I'm not following. You're saying the $#,# format string should already be rounding the numbers, but you can see from the screen capture of my report that two decimal places are showing.

 




danextian's avatar
danextian
Icon for Super User rankSuper User
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.