Show Date dimension even when no value present

[k_burata]

Hi guys,

Trying to create a bar graph to show performance over last 12 months.

Result is correct when no selection is made

But when I make a selection on the currency, Month with zero values disappear.

How do I make it that zero values appear even if I make a selection?

Cheers.

[jyothish8807 · Accepted solution]

try this:

[stabben23]

this could be a work around, add this *avg({1<[Date] = {">=$(v12MonthStart) <=$(v12MonthEnd)"}>}1)

and Your Expression will be

=num(SUM({<[Date] = {">=$(v12MonthStart) <=$(v12MonthEnd)"}>}[Value]), '$#,##0.##')*avg({1<[Date] = {">=$(v12MonthStart) <=$(v12MonthEnd)"}>}1)

[k_burata]

Thanks mate. Solved my problem.

[jyothish8807]

You are welcome