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 

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