Forum Discussion

marcobaciga's avatar
marcobaciga
Icon for Helper I rankHelper I
8 years ago
Solved

set value field in report powerbi by custom visual

Hi, I must in m y custom visual to send a value like filter in each visual object in my report powerbi when i click a icon. Is it possible?   Thank you   Marco  
  • v-viig's avatar
    v-viig
    8 years ago

    This code snippet is going to address the issue:

    let selectionIds = [];

selectionIds.push(host.createSelectionIdBuilder()
    .withCategory(categorical.categories[0], 0)
    .createSelectionId()
);

selectionIds.push(host.createSelectionIdBuilder()
    .withCategory(categorical.categories[1], 0)
    .createSelectionId()
);

selectionIds.push(host.createSelectionIdBuilder()
    .withCategory(categorical.categories[0], 1)
    .createSelectionId()
);

selectionIds.push(host.createSelectionIdBuilder()
    .withCategory(categorical.categories[1], 1)
    .createSelectionId()
);

selectionIds.forEach((selectionId) => {
    this.selectionManager.select(selectionId, true)
});

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

v-viig's avatar
v-viig
Icon for Community Champion rankCommunity Champion
7 years ago

Hierarchy Slicer is on legacy API so far but it will be converted to PBI Custom Visuals API soon once multi column filtering API is released.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

dakdgdl's avatar
dakdgdl
Icon for Helper I rankHelper I
3 years ago

Hi v-viig

 

I tried cross-filte by cross-select as below.

 

--------------------------

let rowSelection: ISelectionId = this.visualHost.createSelectionIdBuilder()
                .withTable(this.dataView.table, rowIndex)
                .createSelectionId(); 
await this.selectionManager.select(rowSelection, true).then(result => {
            console.log(result);
        });
-------------------------------
 
result is just like below
-------------------------
  1. [t]
    1. 0: t
      1. dataMap:
        1. {"identityIndex":0}: [{…}]
        2. [[Prototype]]: Object
      2. deepestNodeLevelInPath: -1
      3. key: "{\"{\\\"identityIndex\\\":0}\":[{\"identityIndex\":0}]}[]"
      4. measures: []
      5. nodeIsCollapsed: null
      6. [[Prototype]]: Object
    2. length: 1
    3. [[Prototype]]: Array(0)--------------------------------
 
But this didn't cross-select the passed selectionID row in other visuals of the page.
What could be the reason. Any specific config setting in tsconfig, capabilities.json or webpack.config
Please advise.
 

Thanks in advance,

Lasantha