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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Filtering calendar by multiple timeranges strange behaviour

*For now I have to put this on hold and dive into it deeper next week. the reproduction of this model works and I probably didnt give enough information to solve this problem. 
**fyi: the connection in Kalender--Einstellungen is inactive and there is another table connected to Bewerbungen which also connects to 'Kalender' (with an active relation). A measure does DISTINCTCOUNT'Einstellungen' with USERELATIONSHIP

Hey guys, I have a calendar which gets filtered by another table 'Zeitraum Filter'. This table contains multiple dateranges for visual filtering purposes in column 'Filter' i.e. ( "2023", "Q1+Q2", "Mid22-Mid23" ... ) with its coresponding dates in "Date" column
(*<>1)

The calendar then filters 'Einstellungen' for the remaining dates in 'Kalender'

It works fine and I can filter 'Einstellungen' with all of those timeranges. The problem lies within 'Bewerbungen'. It has a category column I want to use to filter 'Einstellungen' even further.

Goal should be a visual with activ filters: "Zeitraum Filter"[Filter] = "Q1+Q2" & Bewerbungen[Empf.K] = "Y" showing only those entries in 'Einstellungen'

 

For some reason it works when I use 2023, 2022 ... but as soon as I use one of the "special" timeframes it shows no data. I cant grasp why it works for one but not for the others, they shouldnt be any different but other dates

 

pdhlk_1-1701355646436.png

 

Thanks for your help

 

 

3 REPLIES 3
Anonymous
Not applicable

If I put the Category directly on the visual in the filterspane the basic filteroption even shows me a number of totals I would expect for the category, but the visual doesnt display it.

Ahmedx
Super User
Super User

I can’t say for sure, I think it’s because of the two-directional connection

Screenshot_2.png

Anonymous
Not applicable

But I need those. One Directional wouldnt allow me to filter 'Kalender' by 'Zeitraum Filter' same for 'Bewerbungen' > 'Einstellungen'

I build a tiny version in a new dashboard to test and reproduce this behaviour for you guys, but it works 😓 Now I m even more confused.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.

Top Solution Authors
Top Kudoed Authors