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
rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
2 years ago

All these suggestions led me to a new approach make just a Period Filter.

And I really thought I had done it :

This is what you would want. Everything after 03-2024 should be hidden.

 

But in a graph......

My lines are again gone!

Apparently this solution messes with my DPMO avg line en my UCL line for whatever reason....

This is how it should look:

But for these averages it needs the full time line to calculate te average. 

So most likely there is no good way to not show the future periods and still have the correct lines.

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, rpinxt 

    Thank you very much for your reply, you can try the following two ideas:
    1. You mentioned that these averages of yours need to be calculated based on a complete timeline. Therefore, you can create a calendar table that establishes the appropriate relationship between this calendar and your original table. To recalculate your averages, the timeline you rely on is the calendar table.
    2. When calculating the average, determine whether it is a future time, and if so, then set it to blank(). Or if you try to set up a UCLTest, the main logic is to determine whether it should be [UCL] or Blank() based on the results of the Period Filter, and then use this UCLTest in the chart. The DAX below is a reference:

    UCLTest = SWITCH ([Period Filter],
 "Show",[UCL],
 "Hide",BLANK ()
)

     

     

    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