cancel
Showing results for 
Search instead for 
Did you mean: 

Slicer loses data when time slicer applied

image.pngno slicer selectedimage.pngroadway slicer, working as expectedimage.pngdate slicer killing roadway

I am trying to put together a dashboard where I want to have 2 slicers, one on roadway and one on year.  When I use the Roadway slicer the year is unaffected, but the converse is not true. When I select a year that is not 2017, all of my Roadways disappear. I would expect some of them to come off based on not having data for that year/roadway combination but selecting 2016 kills all of them.

Status: Needs Info
Comments
Moderator

Hi @Bstylee470,

 

Which Power BI desktop version did you run? Based on my test in 2.51.4885.701 64-bit (October 2017), two slicers works fine. In your scenario, please update the desktop to the same version as ours, and you can download our sample file to test on your side to see if the issue related to report. 

 

Also please check if the interaction for the Year slicer is filtered by Roadway slicer: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-11a-create-interaction-betwee...

 

Best Regards,
Qiuyun Yu 

 

 

Established Member
Status changed to: Needs Info
 
Frequent Visitor

I updated to the October Release and i am still having this issue. We have been through our data model and it appears to be built correctly so these 2 fields should not be having this interaction issue. 

Moderator

Hi @Bstylee470,

 

Have you tried the sample file provided in my previous post? It works fine on my side, please check if it works in your environment. 

 

Best Regards,
Qiuyun Yu