CODEWITHSUNDEEP
powerbi
J.S.Orris
J.S.Orris

Reputation: 4821

Power BI: Nested AND statement in URL filter

I have a URL filter that looks like the following:

ReportSection?filter=Utility~2FID%20eq%20%27company%27

I need to modify this URL to add:

AND (Type not equal 1 AND Type not equal 2)

What is the correct format for this to add to the URL filter?

Regards,

Upvotes: 0

Views: 111

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

URL filtering is documented here.

Assuming Type comes from the Utility table,

ReportSection?filter=Utility/ID eq 'company' and Utility/Type ne 1 and Utility/Type ne 2

Upvotes: 1

Related Questions