Forum Discussion
Filtered slicer doesn't show all values
Hey Anonymous ,
basically it works as designed, selections from date slicer are filtering the fact table, this is due to the concept called "filter propagation". The fact table is filtered by the date slicer, but this is not reflected in the SiteName slicer.
Setting the property "Cross filter direction" of the relationship between dimSite and factQuantity once again to "both" will filter the content of the SiteName slicer.
I'm not sure if I really understand your initial question. Maybe you can rephrase it.
Are you missing SiteName in the slicer that have values in the fact table if February is filtered?
Maybe you can prepare some sample data upload an pbix file or an Excel file (that contains sample data that allows to recreate the problem), upload the file to OneDrive or Dropbox and share the link.
Regards,
Tom
Site Name slicer comes from dimSite > SiteName field. I removed a bi-directional cross-filter on dimSite and now any changes I make to Date filter are not reflected on the Site filter at all. It continues to give the full list. they do both filter the fact table data though. I have interactions setup for them to filter each other..
Super UserHey Anonymous ,
basically it works as designed, selections from date slicer are filtering the fact table, this is due to the concept called "filter propagation". The fact table is filtered by the date slicer, but this is not reflected in the SiteName slicer.
Setting the property "Cross filter direction" of the relationship between dimSite and factQuantity once again to "both" will filter the content of the SiteName slicer.
I'm not sure if I really understand your initial question. Maybe you can rephrase it.
Are you missing SiteName in the slicer that have values in the fact table if February is filtered?
Maybe you can prepare some sample data upload an pbix file or an Excel file (that contains sample data that allows to recreate the problem), upload the file to OneDrive or Dropbox and share the link.
Regards,
Tom