Forum Discussion
Create a dynamic column with the values displayed on a table based on the slicer selected.
I'm having a table with two columns Category and Products as shown below.
I'm unsing category column as a slicer and displaying the products in a table visual. Based on the slicer value selected the values in the table changes.
Now I want to create a column which should contain only those products which are displayed in the table visual. For example if the slicer value is Fruits then the new column values should be Apple, Banana, Mango, etc. And if the slicer value is Vegetable then the new column values should be Carrot, Garlic, Ginger, etc. Can we create this dynamic column? Please do help me.
Please note Here I'm using Direct query.
Hope for a positive response.
Thank You
2 Replies
- Greg_Deckler
Community Champion
Simran-Fathima Try using CONCATENATEX
- Simran-FathimaFrequent Visitor
Can u explai in brief. And will it work in Direct query mode?