1 Reply Latest reply: Jan 4, 2017 12:14 AM by Yasmeen KhaderHussain RSS

    How to restrict zeros in bar chart?

    Juna Sharma

      Hi all,

       

      I have a bar chart which displays around 1000000 zeros before actual values are displayed. I just wanted bottom 20 values in bar chart . How can I do this?

       

      I have DSI as a measure and contains negative and positive values in it.(after summing DSI from each condition , I want to remove zeros from below expression

       

      if(GetSelectedCount([Month])=0 and GetSelectedCount([Fiscal Year])=0,

      num(sum({<report_metric_key={'4'}>}DSI),'#,##0'),

      num(sum({<calendar_year_month =  {'$(=Max(calendar_year_month))'}, report_metric_key={'4'}>}DSI),'#,##0')

      )


      Thanks

      Juna