Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sharma,
Try to uncheck the "Show Zero values" from Data Handling Option