Visuals Break with "Error Fetching Data" When Filtering by Date (Import Mode Model)
Hi everyone, I’m facing an issue in Power BI where visuals break and display an “Error fetching data for this visual – An unexpected error occurred” message whenever I try to apply a date filter (as shown in the attached screenshot). Here are the key details: The data model is in Import mode. The error appears specifically when filtering data on TransactionDate (or any date column). The visuals work fine before applying the date filter. I’ve already tried refreshing the dataset and rebuilding the visual, but the issue persists. Has anyone else experienced this issue or found a solution/workaround for it? Any guidance would be appreciated. Thank you!
Slicer issue - Date slicer issue
Hi Power Bi community, I encountered an issue related to dates while using slicers. When I add the same date data into two slicers, I allow the Date1 slicer to filter the Date2 slicer. In the default state, when I change the range of the Date1 slicer, the default range of the Date2 slicer also changes accordingly. However, if I have already modified the Date2 slicer's range, for example, selecting the time range from 2024/7/1 to 2025/3/11 in Date2, even if I reduce the time range of Date1 to 2024/8/1, the Date2 slicer's range does not change. In fact, with Date2, the time period 2024/7/1 to 2024/8/1 is still selectable. However, when I select any date within this range, the earlier dates become grayed out and unselectable. Is this a bug? If not, could you please advise how I can resolve this issue and ensure that the selectable range of Date2 always aligns with the range selected in Date1? Thanks for any suggestionsNeed Help Adding Text Slicer to Table in Power BI
Hi everyone, I'm working on a project in Power BI and need a table that changes its values based on three different slicers. The slicers I need are as follows: First Slicer: Contains text values Second Slicer: Contains numeric values (this slicer is set up correctly and works fine) Third Slicer: Contains a set of measures written with a calculated group (this slicer is also set up correctly and works fine) My problem is adding the first slicer to the table. I'm not sure how to add this text slicer to my table so that the values are filtered based on the selections from the text slicer. Could anyone guide me on how to do this? Any advice or practical examples would be greatly appreciated. Thank you very much
