Forum Discussion

rsathish_red's avatar
rsathish_red
Frequent Visitor
8 years ago

set default value to power bi filter dropdown.

Hi. I have filters in reports (See attached screehshot)   I need to set default value for the dropdown values so the end user will see the report for the selected values. Still they can see oth...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi rsathish_red,

 

How did you pass the value "Asian"?

We can just make a selection in the slicer and SAVE the report then we can share the report with a default selection. Is this good enough?

 

Best Regards,

Dale

rsathish_red's avatar
rsathish_red
Frequent Visitor
8 years ago

I passed variable through the BasicFilter option. See below code

const basicFilter = {
        $schema: "http://powerbi.com/product/schema#basic",
        target: {
          table: "2009 sample V2",
          column: "Ethnicity"
        },
        operator: "In",
        values: ['Asian']
      }

 iframe.onload = function () {
        var msgJson = {
          "method": "POST",
          "url": "/report/load",
          "headers": {  ...  },
          "body": {
            "settings": {
              "filterPaneEnabled": false,
              "navContentPaneEnabled": false
            },
            "filters":[basicFilter],
            "type": "report",
            "tokenType": 1,
            "accessToken": txtAccessToken,
            "embedUrl": txtEmbedUrl,
            "id": txtEmbedReportId,
            "permissions": 7,
          }
        };
        iframe.contentWindow.postMessage(msgJson, "*");

We are using Angular js as frondend to show Reports. It will be dynamic so we need to pass the values while displaying report.

You mentioned about Slicer. Will it be possible to pass it through JS?