The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I had a data table that worked perfectly with slicers, after adding 2025, slicers don't work. The same slicers work perfectly for 2024 or 2023, but when it comes to 2025, one slicer works fine, for example, month
and after selecting the next one, the first one no longer works
selecting 2024, works, but there is no way to choose 2025, as it's no longer there.
any idea whats wrong with this data table, as I only changed end date of calendar, nothing else.
This can happen for few reasons, but I think this is due to the data in the tables. May be there is no data in the table for selected filters for 2025, thus the cell is not visible. Check the tables, and share here it will help understand the issue better. In case you don't want the filters to be affected by the other filters. You can select the slicers, go to Format tab >> select Edit interactions >> and disable for other filters. You can repeat the process for the remaining slicers.