Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with 3 columns (Items, Quantity, Date). I am trying to plot them into a bar chart to find out the no sale months. when I plot them I see bars only for the months that are available in my date column. Is there a way that I can make the x-axis to show all the month of the and plot my data on top of that??
I see this:(example item wasn't sold in all the months, hence i see the below)
and I want to see this:(this example item was sold every month)
So when i chose an item in the filter despite the sale, I want the graph to show all the months in the x-axis and plot my data on top of that, which would help me identify no sale months easily. Could someone help?
Thank you so much in advance.
Try adding +Sum({1}0) at the end of your measure