DiamondJoe12
DiamondJoe12

Reputation: 1809

Filtering in PowerBI - does user see it?

I am building a map with PowerBI, and adding "County" to the visual filter. I only want certain counties to be displayed on the visualization.

Right now, there is 1 county checkbox selected on the filter, so only one county is showing on the map. If I share this visualization (i.e. "publish" it), will the user simply see the checkbox filters and be able to select other counties? I need to have all other counties excluded for privacy concerns and I do not want users to be able to see checkbox options for other counties, let alone be able to display other counties on the map.

Upvotes: 1

Views: 47

Answers (2)

Strawberryshrub
Strawberryshrub

Reputation: 3389

You also can set the visiblity of the filter (buttom right) to Not visible or you can lock the filter (top right).

enter image description here

enter image description here

Upvotes: 0

Alexis Olson
Alexis Olson

Reputation: 40204

You can set it so that it only appears in the filters pane but if privacy is important you need to either filter out the other counties at the query stage so they don't even exist behinds the scenes in the published report or else implement Row Level Security to set who is allowed to see what counties by creating roles and rules you want.

Upvotes: 2

Related Questions