14 Replies Latest reply: Feb 17, 2017 8:42 AM by Vasiliy Beshentsev

# How to view all month?

Hello, everyone!

So what i need to do to see all 12 months in my graph even with zero or null measures??

• ###### Re: How to view all month?

Did you checked show null values option in Add on's tab

• ###### Re: How to view all month?

try this in front end

in dimension

=Month(YearMonth)

• ###### Re: How to view all month?

What is YearMonth?

• ###### Re: How to view all month?

okay. try with  Synthetic dimensions  create variable for months and use that in value list.. like below

“=if(ValueList(\$(VarMonths…”

• ###### Re: How to view all month?

YearMonth field is working?

• ###### Re: How to view all month?

I haven't got this field

• ###### Re: How to view all month?

Change your Expression to show something other than 0; so suppress zero doesn't take effect

= if(sum(Expression)=0,0.0001,sum(Expression))

• ###### Re: How to view all month?

Result:

• ###### Re: How to view all month?

OK, I think you are using the year month field from your fact table and those missing months don't exist in your FACT table.

Use the year month field from your Master Calendar that relates to your fact, the same approach will work

• ###### Re: How to view all month?

So there is no way to show up all months without using master calendar???

It's so sad... I prepared to use this in very last moment...

• ###### Re: How to view all month?

How can we show something that doesn't exist ,

Right now the chart is aggregating over 7 possible dimension values that exist in your FACT

if you create a master calendar that basically fills the gap in dates in your FACT , you will have a list of all 12 months and using the month from the master calendar will cause the chart to aggregate over all 12 months simply because they exist in the Master calendar and then you can use the expression i provided

Hope this makes sense

Cheers

V

• ###### Re: How to view all month?

Dear vasiliy

find the attchment file

I add another expression and the transparent  of it is 100%

• ###### Re: How to view all month?

It's good decision. But master calendar is most powerfull.