Forum Discussion
Creating a dynamic table
Hi everyone, is it possible to create a dynamic table that returns the unique values from a column based on selected slicer. I want to sprint a report to shows daily task count in a a sprint. the number of days in a sprint differs and I want to create a new table that will show a list of sprint days for a selected sprint. Right now the table I created is select the disticnt of all the sprint days respective of the sprint
Hi Anonymous ,
Create a measure like this and apply it to visual level filter.
Measure = SWITCH(TRUE(), MAX('Table'[Sprint])="Sprint 10"&&MAX('Table'[Sprint Day])<=3,1, MAX('Table'[Sprint])="Sprint 11"&&MAX('Table'[Sprint Day])<=2,1,0)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Anonymous ,
Tables are created when the refresh happens.
You can create measures and filter the data to show only the values based on the user selection.
Show us some data example and we can work on it.
Anonymous
Create slicer using the table[Sprint] field (or create a dimension/lookup table with unique table[sprint] vales and join via a relationship to your fact table via the common field) and a table as you have shown. When you select a value(s) in the slicer, the table will be filtered accordingly.
Anonymous , I dynamic table can not be created using slicer.
You can have a dynamic table inside a measure if needed
