BOX PLOT - All Months in X-axis

[NA23]

Hi Everyone,

Can you please help me to display all months of the current year in the x-axis of box plot irrespective of the selection made and irrespective of the data not present in a particular month.

Dimension used is drill down - > Month - Week - Date

Measure used is only(field name)

Attaching a screenshot, where after selecting the filters, the months are getting restricted. Tried to by pass the filters and also the month, but no luck.

[jochem_zw]

Try this:

only({$<Month=>}field name)

[NA23]

Hi jochem, 

tried the expression but after the filters are selected, the months are getting restricted.