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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
reast
Helper II
Helper II

Filter Disappears after Selecting Time frame

I have a dashboard with a time slicer at the bottom, clinician filter, and chart of dollars per client. If I select dates after July 2016, I can also select a clinician to filter the chart. However, any time frame prior results in the clinician filter disappearing. If I select prior to and after July 2016, the clinician filter reappears. I can't figure out why because the clinician table is not linked to the calendar. It's linked to the services on the dollars table. I confirmed that there is clinician data prior to July 2016 on the dollars table. Any ideas?

1 ACCEPTED SOLUTION
AndrewDang
Helper IV
Helper IV

you may want to put a freeze on the tile that you don't want to see it changed. You can click on the Format --> Edit Interactions and put a stop on the sclicer that you may not want to see it changed. 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi reast,

 

>> I can't figure out why because the clinician table is not linked to the calendar.

 

In your scenario, did you place the time field in the slicer to filter data? Based on your checked value in the slicer, other visuals data will be filtered use “equal” operator. E.G. Check June 2016 in the slicer, other visuals will check if underlying table has corresponding records in June 2016. If hasn’t, nothing will display. So I would suggest you check records both in clinician table and other table used by slicer.

 

In addition, I’m not very clear your data, can you share the pbix file to us ? We will check the relationship of these tables.

 

Regards,

Xiaoxin Sheng

AndrewDang
Helper IV
Helper IV

you may want to put a freeze on the tile that you don't want to see it changed. You can click on the Format --> Edit Interactions and put a stop on the sclicer that you may not want to see it changed. 

Thank you! I didn't even know about that functionality. Works perfect. 🙂

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors