Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
@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 .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |