In this Chart, I want to filter the "0" values out of the graphics. However, I want the months (circle) to be still shown.
I tried it with a filter for the Profit and sales values to leave out the "0". However, the months are not shown anymore.
I want to have it like this:
Please find attached my workbook.
Thank you very much in advance
Use Below Calculation
Make a date field as : DATE([Year]+[Month]+'1')
Profit:- IF [Profit] = 0 THEN INT('') ELSE [Profit] END
Sales:- IF [Sales] = 0 THEN INT('') ELSE [Sales] END
You will get Result as below Screenshot
Still Stuck.. Plz Let me know