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,

 

Also, thanks to danextian  and ryan_mayu   for the prompt and helpful responses.

 

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Regards,

Prasanna Kumar