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.

[ahammadshafi]

Hi Kim:

You can check the box with "Show All Values" for the dimension.

-- Shafi

[k_burata]

Hi Ahammad,

Did that and it did showed all but what if I want to limit it to the last 12 months like what I did on the expressions tab?

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

Cheers

[ashwinishinde]

Dear Concern,

Try This,

[shiveshsingh]

Try this, hope this helps.

[k_burata]

Hi Shivesh,

I would want to show the last 12 months. Is there a way to do this?

Regards,

[k_burata]

Hi Ashwini,

This would work if I did not select a Currency. Once I select a value from currency this does not work anymore.

Regards,

[jyothish8807]

Hi Kim,

Try the sample attached.

I have simple updated your variable for my reference, you can revert them.

I have created a new filed called as counter , which have value 1.

Then created a new expression and disable the chart type.

Br,

KC

[k_burata]

Hi KC,

Thanks for this. But what if I only want to display 12 months of data only? Like for the past 12 months?

Regards,

[jyothish8807]

Same logic, just change your variables as it was earlier.

I just modified it for my reference