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,
When interaction with one of our Power BI reports I noticed that not all values are visible in the Report Filter Pane, in the right panel. For example we have a report filter with all our suppliers, but I can't scroll down further then suppliers starting with D.
I have to go into the advanced filter pane. Is there a limitation on number of items in a report filter?
Sincerly Nathalie
Solved! Go to Solution.
Unfortunately, it limits the items visible. If you use advanced filter you only have two fields. I work around thisshortcoming by adding a slicer to the report on fields where I need to filter by more than two choices. Using CTRL+Click I am able to select as many as I want in the slicer.
Proud to be a Super User!
Hi Nathalie,
As a workaround to Filters - if you like to investigate a value in a table you can use the Text Filter under Visualizations. This one will filter all values.
The Text Filter is not a standard visual but you can easily add it by going to 'Add more visuals'- the symbol is that of a magnifier.
Kind regards,
Pascal
Not sure this can be marked as solved??
The issue still remains even though there is a work around - I have a filter which goes into 100s - there is no way of slicing this into smaller chunks - The PBI devs need to look at this again...
Cheers
Unfortunately, it limits the items visible. If you use advanced filter you only have two fields. I work around thisshortcoming by adding a slicer to the report on fields where I need to filter by more than two choices. Using CTRL+Click I am able to select as many as I want in the slicer.
Proud to be a Super User!
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 |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |