Embed - Javascript Filtering

[daneri]

Hey!

I have a report embedded into my website, and I'm trying to set up filtering based on user roles by adding a filter to the config using javascript.

const basicFilter = {

        $schema: "http://powerbi.com/product/schema#basic",

        target: {

          table: "someTable",

          column: "someColumn"

        },

        operator: "In",

        values: ['valueBasedOnRole'],

        filterType: 1,

      };

This filter works fine for most of my users, they mostly have one or two values which I can add to a list. My Question is for my Admin Users; I want to basically filter on 'All' (letting all the values pass through the filter). Is there a value, or operator/value combination which lets me do this, eg. "*" or "All".

I know this is the same as just not applying the filter, or adding all the values in the filter ( with over 300 different values this isn't really an option) so I'm mostly curious how this kind of filtering works and wanting to have an answer for future cases.

[v-xuding-msft]

Hi @daneri ,

Please check more details on PowerBI-JavaScript wiki - Filters. Hope it will help you a little.

Best Regards,

Xue Ding

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