Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
A |
aa |
ab |
B |
ba |
bb |
bc |
C |
ca |
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.
Since the HierarchySlicer provides similar functionality, you could download it and try to view its source code.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |