How to restrict zeros in bar chart?

[Anonymous]

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

[yasmeenk]

Hi Sharma,

Try to uncheck the "Show Zero values" from Data Handling Option