Cant remove filter from Date Quarter

[IraWatt]

Hi all, Im trying to remove the filter from my date field which on my graph is broke down by quater. When I try REMOVEFILTERS() it works:

However, REMOVEFILTERS('Key'[Simple Application].[Quarter]) does not have the same effect.

Im not sure what is wrong with my setup. 

[v-chenwuz-msft · Accepted solution]

Hi @IraWatt ,

You are very right with method to remove the quarter filter. But you miss the [QuarterNo]. Exactly, there is a table contains columns named year,month,monthNo,quarter,quarterNo,day when you enable intelligence date time. The table has one  to many relationship with your fact table. So you want to remove the filter on this table, not only the quarter but also quarterNo.

Best Regards

Community Support Team _ chenwu zhu

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

[IraWatt]

Awsome thanks @v-chenwuz-msft! It seems strange that the graph applies both the QuarterNo and Quarter as filters almost like it has two fields in the x-axis. 

[amitchandak]

@IraWatt , try like

REMOVEFILTERS('Key'[Simple Application])

Prefer not to use the Auto time intelligence column. Create a Qtr column. Or create a date table with the required column .