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 ideas on how to acheive this would be greatly appreciated.

 

Cheers

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.

10 Replies

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi again

      no joy on what i was trying to acheive 😞

       

      So some more detail and a change of direction is needed i think, in the dataset which is one big table each month is allocated a number (PERIOD) 01,02,03 etc but they are not as you expect July is 01 Aug 02 Sep 03 etc. The table also has of course a month as well Jan, Feb, Mar etc but has NO transaction dates

       

      I need to put a filter on the visual that will say ok you are now in the month of April =10 and you want to show 6 months in the future so that would be May =11 June =12 July =1 Aug=2 Sep=3 Oct=4

       

      So BI needs to look at the current month then using smarts display the next 6 months i know that manually i can drop the PERIOD as a fiter then manually select the next six months and the visual then changes but the goal is to make it happen automaticaly

       

      Sorry a bit tired so this may not make sense.