Creating a dynamic table

[Anonymous]

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

[amitchandak]

@Anonymous , I dynamic table can not be created using slicer.

You can have a dynamic table inside a measure if needed

[Anonymous]

How do I achieve that

[camargos88]

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]

Below is a sample data.

I want to the table to show Days: 1,2,3 when I select Sprint 10 and just 1,2 when I select Sprint 11

Sprint Day	Sprint	Tasks	Assigned	Hours
1	Sprint 10	Task 1	User A	2
1	Sprint 10	Task 2	User A	1
2	Sprint 10	Task 1	User B	2
3	Sprint 10	Task 3	User C	1
1	Sprint 11	Task 1	User C	2
2	Sprint 11	Task 5	User A	1

[PaulDBrown]

@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. 

[V-lianl-msft · Accepted solution]

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.