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.
I have the 'Edit' option in power BI service and I wanted to do a quick modification to a report.
I have a specific value in a filter for a Dimension that I want to remove.
(I know the correct fix would be to eliminate this wrong entry in the Dim table, but I don't have access to the source).
It's the DimProvince, and there is a row which is not a Province (this shows up in the filtering option): is there a quick way to not display that wrong value in the filter options?
Solved! Go to Solution.
Hi. Let's see if I understand. You have slicer filter in province and want to hide one of its values. In order to do that. Click on the slicer, and add a Visual Level Filter on the Filter Pane like province name. Then select all values and unmark the one you don't want to show up there.
Hope this helps,
Happy to help!
Hi @ovonel ,
You could use URL filter to remove wrong value.
The basic syntax is fairly straightforward, as follows:
URL?filter=Table/Field ne 'value'
Reference: Filter a report using query string parameters in the URL
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ovonel ,
The ability of you to update the report totally depends on how the report was shared with you, whether or not the edit access was given to you.
Please look for the available filters in teh report and see if the relevant one is present for you to get rid of the unwanted values.
Hi. Let's see if I understand. You have slicer filter in province and want to hide one of its values. In order to do that. Click on the slicer, and add a Visual Level Filter on the Filter Pane like province name. Then select all values and unmark the one you don't want to show up there.
Hope this helps,
Happy to help!
Thanks, not sure if it is a "add a Visual Level Filter" I added a 'Filter on all pages' in the filter seciton and that worked...
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.