Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Removing decimals from values while keeping for totals

Hi, I have table that has some counts. However I cant find a way how I could remove delimal points from values in red square while keeping decimal points for values in green square. I tried couple ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Unfortunately, with live connection, you will need to apply the dynamic format string to the measure in the semantic model itself. Alternatively, you can create another measure that returns a formatted text instead

    IF (
    NOT ( HASONEVALUE ( Geo[Geo] ) ),
    FORMAT ( [my measure], "#,#.00" ),
    FORMAT ( [my measure], "#,#" )
)
danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi Justas4478 

 

Apply dynamic format string to the measure being used in the viz. In the screenshot below, "#,#.00" is being applied to the column total wherein geo has no single value (as it has multiple at the total which are the indivdual geos) otherwise, "#,#".

 

  • Justas4478's avatar
    Justas4478
    Icon for Post Prodigy rankPost Prodigy
    1 year ago

    danextian I tried your solution as well, but same problem it requires column while I can only provide measure.

     

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      1 year ago

      Apply dynamic format string to a measure but reference the column in your formula. You are referencing the measure the string is to be applied to and not to the dates.

      • Justas4478's avatar
        Justas4478
        Icon for Post Prodigy rankPost Prodigy
        1 year ago

        danextian I quickly looked in to and it seasm I cant create dinamic format since it is on for model measures and not ones using live connection.