cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joecorestack
Frequent Visitor

Filter values are not filtered properly

Hi,

 

    I have created a small sample report to explain the issue I'm facing. You can download the report here.

 

    I have added the RLS in the report. I have issues on the available values of the Report Filter.

 

To reproduce the issue, please do the below steps

1. Click on View As Roles, Select Other User and Type "Joe" in the text box then select the Viewer Role click Ok

2. Now the data is shown on the table related to the user "Joe".

3. When I see the report filter "Environment" there is only one value "QA", because "Joe" is only mapped to "QA". But if you see the "Status" filter it shows both "Active" and "Deleted". I want the filter to display only "Active" because the user has only one possible value there. But "Status" filter shows both "Active" and "Deleted"

 

tmp.png

 

Thanks.

4 REPLIES 4
Super User III
Super User III

Re: Filter values are not filtered properly

Hi @joecorestack ,

 

However the user Joe only has one state the table has two possible result active or inactive so you see on your filter both of them however if the user select the inactive one it will get blanks.

 

If instead of adding the Status from the Status table you add the StatusID from the Users table you will see that you only get one option.

 

This as to do with the way your table is setup and the final result depends on your structure and way you have the model. If you turn off the bi-direction on the tables you will see that the filters will have the full results of your tables, also the bidirectionality and the fields you use for each of your filters changes the filter context and the final outcome of the visualization.

 

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


joecorestack
Frequent Visitor

Re: Filter values are not filtered properly

Hi @MFelix ,

 

   Thanks for your reply. I have made some changes in the report to have multiple possible status for a single user and you have download it here.

 

   Is there any other way we have have only the possible statuses on the filter?

 

   In complex model it will be difficult to merge the tables as every dimension will have its own fields and can't be merged with other table.

Highlighted
Super User III
Super User III

Re: Filter values are not filtered properly

Hi @joecorestack ,

 

Sorry for making the question but what is the purpose of these filters having only those values?

 

Just want to understand the thinking behind it and help you in the right direction, sometimes for usage purposes other options are better than the filter pane.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


joecorestack
Frequent Visitor

Re: Filter values are not filtered properly

Hi @MFelix ,

 

     In the example, I have a user "Joe" who has two service account "Acc1" and "Acc2" both are "Active". So when I login as "Joe" (impersonate the user to apply RLS) when the user see the filter pane only the "Active" status should be there, because he don't have any service account with "Deleted" status.

 

Thanks

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors