Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Filter issue

Hello ,
i'm trying to visualise data in the current week if i dont touch the filter week  and when i select a week in segment i get data from that week but the problem that when i select all weeks power bi thinks that i didn t aplly any filter and visualise the current week .
How can i fix that . if i select all weeks i want to get data from all weeks and not the current year.

2 REPLIES 2
Anonymous
Not applicable

i've already used isfiltered my problem is that when i do not filter all field selected return the actual weeks and im having problem visualiasing all field because of passing ressource limit . Have you any solution to optimise ressources other than having premieum version

 

amitchandak
Super User
Super User

@Anonymous , use isfiltered to switch

 

if(isfiltered(table[segment]), [week measure], sum(Table[value]))

 

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.