Is there a way to create dynamic table that filters when using slicers?

[Anonymous]

Im looking for a solution to perform cumulative column calculation but needs to have a dynamic table that filters whenver i use slicers

[Anonymous · Accepted solution]

Hi @Anonymous ,

Normally, the table is in static form. However, depending on your specific business needs, you can achieve the same effect in other ways.
For example, you can use the Bookmark function to create a Button instead of a slicer to achieve the "dynamic table effect".

You can also use the unpivot function in the power query to convert the table first, and then use the attribute column as a slicer after the conversion, and the value column in the new table as a dynamic row.

I think the above suggestions can achieve a similar effect, I hope it will help you.

Best Regards,
Stephen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , No, Table are static. You can create a table as var in measure.

But that will be available to that measure and you need to repeat that in all measures you need