19 Replies Latest reply: Jul 20, 2017 6:00 PM by Greg Crowe RSS

    Number format within a Chart

    Greg Crowe

      Shown is my set expression within a measure on a chart:

      if(vMeasurement = 'Count',

      Count({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'}>}[Incident Number]),

      Sum({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'}>}[Duration])

      )

       

      By the if statement, I will either be displaying a number or a duration. How do I change the formatting of the number within the chart? I've tried using custom, and adding 'Interval' to the part of the expression with the sum of the duration, but I can't get it to work.