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'm using parameters to allow users to filter report data based on allowed values in a dropdown. A blank value means 'don't filter' in the DAX behind. As an example (not the actual report)
Note that allow blank value is selected.
In available values, I add a few, one of which is blank:
This works fine in the report builder; I can run the report and choose anything from the dropdown and the filters are correctly applied. However, when the report is published to the Power BI service, while the dropdown item with the blank value is displayed, it is not selectable. If it is the first item in the list, then the filter is applied correctly, but if the user selects another item, then tries to select 'All' again, there is no response. The other items continue to work. The same problem happens if the blank item is elsewhere in the list.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I suggest you to open a support ticket to ask for the opinions from the technical support team of Microsoft to check if this is an issue that existed in the Power BI.
https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...
https://powerbi.microsoft.com/en-us/support/
Thank you very much!
Best Regards,
Community Support Team _Robert Qin