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
Super UserHi Anonymous ,
Where is the SiteName slicer comming from? Are you getting this value from the factquantity table or from one of the other tables?
When having slicers based on your fact table they will be influenced by the values that you place on other slicer in this case you will only get the data that is for February.
Can you share how you have the full model setup and the slicers?
Regards,
MFelix
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..
- TomMartens
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