Null values in chart

[Karl_Hart]

I have a table that uses the expression

=sum({$<FiscalMonthNumeric = {"<=$(=max(FiscalMonthNumeric))"}, Month=>}Data)

and the results of this are

Apr     5%

May     6.78%

Jun     0%

Jul     4.76%

Aug     1.75%

The bar chart only shows the results that aren't 0 (i.e. Apr, May, Jul and Aug)

I have "Show All Values" selected but it makes no difference. How do I get it to show June's zero figure?

Thanks

[PrashantSangle]

Hi,

Uncheck supress Null Values and Supress Missing from Presentation tab

and Check Show all VAlues in dimension tab

Regards

[Karl_Hart]

Cheers Max, that adds Jun but it also add future months which I dont wish to show yet. Is there something in the set analysis I can do to remove those?

Thanks

[Karl_Hart · Accepted solution]

The below gives me the correct results I need to show only valid months based on my selection, but also includes null values (Also I have the "Show All Values" unticked on the dimensions tab