Forum Discussion

Goofr's avatar
Goofr
Icon for Advocate IV rankAdvocate IV
8 years ago

Report Filter "Require single selection" not working

When I publish a report containing report filters with the option "Require Single Selection" to the Service, this option is neglected. In the Desktop it works as expected. When I change the report ...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Goofr，

 

By my test with the report created on Power BI Desktop(Version: 2.57.5068.501 64-bit (April 2018)), I cannot reproduce your issue.

 

Here is my test result.

 

 

Could you show me your issue screenshoots? You could try to open your Power BI Service by other browser to check if there is still a issue. 

 

In addition, if it is possible, you could share your sample which can reproduce the issue, so that I can test it in my environment? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry

  • Goofr's avatar
    Goofr
    Icon for Advocate IV rankAdvocate IV
    8 years ago

    Hi,

     

    So I created a new Power BI report with Direct Query access to Azure SQL db.

    I'm using version 2.57.5068.721 64-bit.

     

    The report filter in PBI Desktop is set as "Require single selection".

     

    In the Service this becomes:

     

    You can find the report here : TestReportFilter

     

    Thanks in advance

     

    Frank

    • Goofr's avatar
      Goofr
      Icon for Advocate IV rankAdvocate IV
      8 years ago

      Any news on this topic?

      Still not working...

       

      Frank

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        8 years ago

        Hi  Goofr,

         

        I have made a test with connecting data source by Direct query, I can reproduce your scenario in Reading Model.

         

        By my tests, when you change to Edit model,  the Report Filter "Require single selection" will work. 

         

         

         

        Best regards,

        Cherry