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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, rpinxt 

You can turn off the show items with no datas option on the date field of the X-axis as shown in the image below:

The effect of turning off this option is as follows:

It would be great if it helps you.

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

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

Hi Anonymous no this will also not help unfortunately.

Because if you do this also the blank periode in the year 2023 will be gone.

 

I only want to hide the period of 2024 which are in the future.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, rpinxt 

    Thank you very much for your reply. I did a diagram and it originally looked like this:

    I did this by putting the year of the hierarchy in the page filter, as shown in the image below:

     

     

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

      Thanks Anonymous but this is also not the solution.

       

      This is the case :

       

      So all periods without data in 2023 should stay.

      (ie 04-2023, 06-2023 etc)

       

      Yes that will work when I switch off 2024 but as you see 01-2024 has data.

      And later also other periods in 2024 will have data.

       

      Actually it is like this. We are now in period 03-2024.

      All periods after that should not show.

      But this has to be dynamic because next month 04-2024 should show and all others should not.