Create dynamic table based on the slicer selection

[Sab]

Hello,

I have a Date column having dates from the beginning of this year, to present day.

I need to create a dynamic temp table that will have dates from the firstdate in the Date column, to the selected date from the slicer, so if the selected value is Feb. 1st then the table will have 30 rows, if the selected value in slicer is 15 Feb, then the table would have 45 rows, etc.

Thanks

[amitchandak]

@Sab , you can not create a table using the slicer value.

[Sab]

RIP

[V-lianl-msft]

Hi @Sab ,

You cannot create a dynamic table at the model view, but you can create a dynamic table visual at the report view.

First create an unrelated calendar table as slicer, and then create a measure applied to the table's visual level filter.

Table 2 = DISTINCT('table1'[date])

Measure = IF(MAX('table1'[date])<=MAX('Table 2'[date]),1)

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

[prabhatnath]

Hi V-lianl-msft

Can you suggest my question?

https://community.fabric.microsoft.com/t5/Desktop/Best-way-to-represent-Tabular-Data-as-Row-Headers/... which looks similar to this thread, but I am not sure how can I do that dynamic table visual based on the Slicer selection.