Forum Discussion
How to create a dynamic Column
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.
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.