topic Re: Set slicer value upon load Javascript API in Developer

Set Relative Date Slicer value upon load Javascript API

fatgreycat — Wed, 22 Aug 2018 03:07:20 GMT

Hi all!,

Im attempting to set a slicer value upon report load. According to this documentation this can be done:

https://github.com/Microsoft/PowerBI-JavaScript/wiki/Slicers

Could someone please check my code below to see if i'm missing something or help confirm that this functionality is not working?

        var filter = new models.RelativeDateFilter(
            {
            table: "D_DATE",
            column: "DATE_VALUE"
            },
            models.RelativeDateOperators.InLast,
            30,
            models.RelativeDateFilterTimeUnit.Days,
            true
        );

        //relative date
        slicerObj.push({
            selector: new models.VisualSelector("a0625ab0110ec10492e3"),
            state: filter
        });


        var config = {
            type: 'report',
            tokenType: models.TokenType.Embed,
            accessToken: accessToken,
            pageName: summaryPage,
            embedUrl: embedUrl,
            filters: basicFilter,
            slicers: slicerObj, //THIS DOESN'T DO ANYTHING?
            id: embedReportId,
            permissions: models.Permissions.All,
            settings: {
                filterPaneEnabled: true,
                navContentPaneEnabled: true
            }
        }; 

       var reportContainer = $('#reportContainer')[0];
       var report = powerbi.embed(reportContainer, config);

Re: Set slicer value upon load Javascript API

v-jiascu-msft — Mon, 06 Aug 2018 02:45:15 GMT

Hi @fatgreycat,

I have consulted some experts. I will update here when I get the answer.

Best Regards,

Dale

Re: Set slicer value upon load Javascript API

v-jiascu-msft — Tue, 07 Aug 2018 02:49:04 GMT

Update the report ID: CRI 79433674.

Best Regards,

Dale

Re: Set slicer value upon load Javascript API

fatgreycat — Tue, 07 Aug 2018 02:53:26 GMT

Hi Dale,

Sorry I don't understand what you are asking me to do?

Re: Set slicer value upon load Javascript API

v-jiascu-msft — Tue, 07 Aug 2018 03:20:50 GMT

Hi @fatgreycat,

Sorry for the confusion. It's a reference to other teams. You don't need to do anything.

Best Regards,

Dale

Re: Set slicer value upon load Javascript API

v-jiascu-msft — Tue, 14 Aug 2018 05:47:27 GMT

Hi @fatgreycat,

There aren't any issues. I made it work with the following code finally. (the main part is as follows.)

var models = window['powerbi-client'].models;

const slicer_filter = 
    {
        selector: new models.VisualSelector("97cc6177cbc5e4a48834"),
        state: {
            filters: [
                {
                    "$schema": "http://powerbi.com/product/schema#basic",
                    "target": {
                        "table": "DimProduct",
                        "column": "ColorName"
                    },
                    "operator": "In",
                    "values": [
                        "Blue"
                    ]
                }
            ]
        }
    };

var config= {
    type: 'report',
    tokenType: tokenType == '0' ? models.TokenType.Aad : models.TokenType.Embed,
    accessToken: txtAccessToken,
    embedUrl: txtEmbedUrl,
    id: txtEmbedReportId,
    slicers: [slicer_filter],
    permissions: permissions
};

var embedContainer = $('#container')[0];
var report = powerbi.embed(embedContainer, config);

So please check out these things below.

1. The format of the filter,

2. The slicer is an array.

Best Regards,

Dale

Re: Set slicer value upon load Javascript API

v-jiascu-msft — Mon, 20 Aug 2018 02:17:17 GMT

Hi @fatgreycat,

Could you please mark the proper answers as solutions?

Best Regards,

Dale