How to view all month?

[Vasiliy_Beshentsev]

Hello, everyone!

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

[Anonymous]

Dear vasiliy

find the attchment file

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

[vinieme12]

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

[Vasiliy_Beshentsev]

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

[Chanty4u]

YearMonth field is working?  

[Vasiliy_Beshentsev]

I haven't got this field