Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show only months up until the current one.

Hello,

I have this chart, and it shows all the months in dbFiscalCalendar, however I would like it to show just the current month and all the past ones, but not the future months.

 

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could create a measure and add it in the filter pane.

    Measure =
IF (
    SELECTEDVALUE ( Table[Date] ) <= TODAY(),
    1,
    0
)

    Then show the result whose measure is 1.

     

3 Replies

  • jairoaol's avatar
    jairoaol
    Icon for Impactful Individual rankImpactful Individual
    6 years ago

    you have several options

    - You can apply a filter at the level of the date table where you identify the months of January already the current one.

    - You can apply a relative date filter for the current year and also a value measure filter so that it does not display empty values.

    - You can apply a slicer per month filter for the user to choose the months to consult.

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , You can use the filter.

    You can have a column like this in the date table

     

    Month Type = Switch( True(),
    [Date] <= eomonth(Today(),-1),"Selected Months" ,
    "Future months"
    )

     

    and filter on Selected Months

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    You could create a measure and add it in the filter pane.

    Measure =
IF (
    SELECTEDVALUE ( Table[Date] ) <= TODAY(),
    1,
    0
)

    Then show the result whose measure is 1.