Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Morning,
Is there a simple way to remove the blank (1823) from the filter page and only show options with responses? I have searched for a solution and tried to select all and untick the blank, padlocked and published but that didn't work.
Many thanks,
Aquarius
Thank you both and apologies for the delay in response. I've left the blanks in the end so not to delete the data. Thank you.
Hi @Aquarius ,
The fields in the filter are the contents contained in the dataset. Unless you delete the blank fields in the dataset, they will be displayed in the filter.
You can also set the filter to a non blank field in the report level filter, and then the blank field will not be displayed in the page level filter and visual level filter.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Aquarius
I'm assuming that you are happy to both remove the Blank option from the list of filter options, as well as filter the entire report to exclude Blank.
If so, you could try this:
Does that work for you?
Regards,
Owen