cancel
Showing results for 
Search instead for 
Did you mean: 

Can't select dropdown item where associated value is blank in paginated reports

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)

justin0123_0-1638762232099.png

Note that allow blank value is selected.

In available values, I add a few, one of which is blank:

justin0123_1-1638763583050.png

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.

Status: Investigating

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

Comments
v-robertq-msft
Community Support
Status changed to: Investigating

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

Anonymous
Not applicable

I suggest you check and update your how-to. The entire 'Still having issues' section no longer exists and  the 'Report an issue' section takes me to this very forum.

v-robertq-msft
Community Support

Hi, 

Please go to the Power BI support page and click on the “Get support”

vrobertqmsft_0-1639017389828.png

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin