Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
2 years ago

Hide future month from my graph

One would think this is not that hard but still I am having a hard time. This is the case : I already build a current period filter like : Current Period Filter = IF(     MAX(dimDate[Date...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

rpinxt , Please check value of current period

 

Hope current period like = Maxx(allselected(Table), Table[Date])

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • rpinxt's avatar
    rpinxt
    Icon for Solution Sage rankSolution Sage
    2 years ago

    amitchandak could you explain bit more what you mean with :

    Hope current period like = Maxx(allselected(Table), Table[Date])

     

    Do you mean this line where I have Current period:

    Current Period Filter =
    IF(
        MAX(dimDate[Date]) <= [Current Period],
        "Show",
        "Hide"
    )
     
    To change my measure [Current Period] with the measure you suggest?