Setting a default filter with zero output and using Query string parameter filters in URL

[sanman]

We can filter the data in report by adding url paramter ?filter=Table/Column eq 'value'

I want to use this scenario to show customer related data for customers who are logged into my web app.

I know there might be some savvy user who takes out the filter parameters and see all other customer related data. 

Is it possible to have the default set to some fake customerID then only show correct report if a correct customerID is included in the URL filter?

[v-xicai]

Hi @sanman ,

Your demand is a good idea, while it is unsupported to set Row Level Security for different customer roles in URL parameter in Power BI currently. You may post your new idea in Idea Forum , add your comments there to improve Power BI and make this feature coming sooner.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@sanman You could use ISFILTERED and if it is not filtered return BLANK()?

[sanman]

I am new at this so would appreciate if you could explain further where to use the isfiltered and where to return blank() ?

[amitchandak · Accepted solution]

@sanman ,

//making measure blank

if(isfiltered(Table[Customer]), [Measure], blank())

//use this measure at visual level filter , =1, will make visual blank if not filered

if(isfiltered(Table[Customer]), 1, 0)

Also refer

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/