Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Showing current and future months

Hi All Probably an easy thing to do but i am trying to have on a line chart the current month as the AXIS plus any month moving forward we do not want to see the previous months and their data. Any...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Has your problem been solved? If not, please show us a sample data.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous,

You could do it by creating a calculated column to determine if each date matches the condition you are looking for. 

Check column = 
IF( Calendar[Date]>=TODAY();1;
IF( Calendar[Year]=YEAR(TODAY()) && Calendar[Month]=MONTH(TODAY()) ;1;
0))


Br,
J

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the quick response, definately not my area of expertise on that.

So i can definately create the calculated column i gather i then use that as the axis or do i use it as a filter on the visual, that is the part i am not sure on.

 

Ta

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    6 years ago

    You will need to use it as a filter! If you want you can modify the column slightly to return dates instead of 1's and 0's which would allow you to use it as the axis dimension. 

    But right now all you need to do is apply it as a filter 🙂

    Br,

    J