Forum Discussion

faisayed's avatar
faisayed
Frequent Visitor
3 years ago
Solved

Future Months Showing In Bar Graph

Hi Team,   I have created a Date table with formula Reference Table = CALENDAR(DATE(2022,1,1),DATE(2023,1,31)) which gives me dates from 1st Jan 2022 till 31st Jan 2023. However when I am uising t...
Need Help
  • pratyashasamal's avatar
    pratyashasamal
    3 years ago

    Hi faisayed ,
    You can add column MonthYear Column in Reference Table that has Month+ Year .And then use that as a filter .
    Thanks ,
    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C

faisayed's avatar
faisayed
Frequent Visitor
3 years ago

pratyashasamalThanks for your prompt response.

I have tried that but it still gives me the same issue and if I deselect the futur months it also removes the previous months as months are not categorized with years. For example I deselct Feb, it will deselect Feb for Previous year as well.

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    Hi faisayed ,
    You can add column MonthYear Column in Reference Table that has Month+ Year .And then use that as a filter .
    Thanks ,
    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C