topic Re: Selection for table in Developer

Selection for table

gendalf7771 — Thu, 01 Sep 2016 10:32:27 GMT

Hello!

I have a two related columns (string type). It can be represented so:

Col1	Col2
A	aa
A	ab
B	ba
B	bb
B	bc
C	ca

I need to create a visual with dropdown menu, which will contains values from both columns, but only second column's values are selectable, like so:

That is, I select unique Col2 value and other visuals get filtered. I've made this menu with such table mapping:

"table": {
  "rows": {
    "select": [{"for": {"in": "col1"}},{"for": {"in": "col2"}}]
  }
}

And now I'm stuck in interaction with other visuals because selections can be apply only for categorical view. Is there a way to use selections in my visual or I need to go to other data mapping? I just want to click one unique value and filter other visuals. Thanks.

P.S.: don't offer me to use visual gallery examples.

Re: Selection for table

v-chuncz-msft — Mon, 05 Sep 2016 03:00:24 GMT

@gendalf7771,

Since the HierarchySlicer provides similar functionality, you could download it and try to view its source code.

Re: Selection for table

gendalf7771 — Mon, 05 Sep 2016 06:40:36 GMT

Sam,

I've tried to use that code. But in Power BI visuals CLI tool there's no objects, used in HierarchySlicer: utility.SelectionManager, ITreeView, IInteractiveBehavior, ISelectionHandler, etc. Apparently that visual was developed by the web tool. And this is another one problem: code for web-tool is different from that is described in Power BI visuals CLI tool. Considering web-tool now is not recommended and not supported, code for it doesn't make sense.