Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
Relatively new to BI so apologies in advanced.
I have a pretty simple model which got data from an excel workbook. All my visuals on my model appear to have a filter as pictured, which I don't remember adding. I can't remove it as it is greyed out. The date slicer allows me to pick dates outside of the filter, but no data appears as the filter is still applied.
I don't know how this filter got there, or how to remove it. I am the only user as of right now.
Edit: Data outside the filters range exists withing the tables in the dataset.
Solved! Go to Solution.
@Sankey9913 , click on the filter. You should have the option to clear it.
what version of power bi you are on, make sure you are on latest version
@Sankey9913 , click on the filter. You should have the option to clear it.
what version of power bi you are on, make sure you are on latest version
I cannot click on the filter... it is greyed out. If I right click, all the options are also greyed out.
On Version 2.88.1385.0
@Sankey9913 , very strange. Are you able to do any other changes? (is the file read only)
Open power query and check for any error and try to resolve if any.
It was the only thing it wasn't allow me to do (that I had noticed at least). There were no errors of any kind, and all my data was loading correctly, just not viewable.
I actually just got it to work, I signed out and back in and it allowed me to remove them.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |