Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
i have a load of data but most of the time i only import 1 or two days.
i have a data table but my filter for days shows all days, even tho there is only data for thursday. i thought the day filter would only show Thursday as a possible selection
There is only data for Thrusday in the data, not sure why the the filter would show all dates as selectable
Hi @NewbieJono ,
How many tables are in your model? The two slicers in the screenshot (Date slicer and DayName slicer) come from which table and which field? If you have only one fact table in your model and both slicers come from fields in this fact table, also if the fact table only has data for Thursday, then the slicer may only show the Thursday option and no other option. Otherwise, the slicer options are displayed depending on the data in the table, the relationship between the tables, and the selection of the fields used as slicer options.
Could you please provide some sample data from the involved tables(exclude sensitive data) in order to make troubleshooting? It would be better if you can share a simplified pbix file without any sensitive info. Thank you.
Best Regards
@NewbieJono , Not very clear. If date is selected from the same table or joined table (based on filter direction) then it should filter day
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |