How to stop the graph plot if value is reached its maximum

[Anonymous]

I Have onje report where i need to stop the graph plot after it reaching maximum value.In the above picture the IN_WAVE_PERCENATGE(Green) is reached 100% in 3 days only.I want to stop the graph plot once its reach its maximum percentage instaed of its dragging till 25 days with same percentage(Here cumulative sum is used in table)

[v-yuta-msft]

@Anonymous ,

You can create a report level filter on [DAY] column and set a filter like "less than 6". Then the line chart will be filtered in less than 6 days.

Community Support Team _ Jimmy Tao

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

[Anonymous]

But 6th day is not fixed one.the no of days is dynamic

[v-yuta-msft · Accepted solution]

@Anonymous ,

The built-in slicer can't be dynamically changed based on the values in the column. As a workaround, you may create several measures on %wave and other percentage columns using DAX like pattern below to filter the 100% value:

Result =
IF ( MAX ( [%WAVE] ) < 1, MAX ( [%WAVE] ), BLANK () )

Community Support Team _ Jimmy Tao

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