Forum Discussion
How to create a dynamic Column
Hello, I have the following problem. I have a table like such: CLIENT DATE TARGET SALES ON DEP. A SALES ON DEP. B AMADOR 01/02/2022 aaaa 10 0 JOHN 01/02/2022 xxxx 12 13 JACK...
Hi Anonymous ,
The clear answer, slicer or filter pane does not work for any table in the data view. The data always from data table to page never than turn back.
If you want to put the STATE in the filter pane , you can put the measure in to filter pane on this visual directly. it works.
- And create a table contains all the result of STATE measure , put the table in the slicer,
- then compare the values selected in the slicer with the result of STATE measure, a new measure named IF, if the same then 1 else blank.
- Put the IF measure in filter pane.
But, if you have many visuals on this page, you need to add them one by one.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes!! I ended up doing somehting of the sort, so thank you! I hope the post helps many people as well 🙂