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

Correct. There's no way to filter by two or more columns at the same time.

 

Such a feature is landing soon (most likey by end of this year).

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

seregindv's avatar
seregindv
Frequent Visitor
7 years ago

No way. I can't wait that long. HierarchySlicer can already do this and I probably can filter in the same way it does. How does it do this?

  • 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