Forum Discussion

Simran-Fathima's avatar
Simran-Fathima
Frequent Visitor
3 years ago

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