undefined

[Akshaykadam98]

We have a requirement in our project we are having weekly data like 

2023-47

2023-46

2023-45

This column data type is text, every week new weeks data update in this column like 2023-48

We want data selected for last 5 weeks

How can I create a dynamically selecting slicer when data type is text,

Slicer will select last 5 week's automatically 

[Fowmy]

@Akshaykadam98 

Currently, automatic selection of slicer value is not possible. Please redefine your approach.

[Akshaykadam98]

• So what should I create if I have to show latest 5 weeks data, my weeks column is in text data type

[Fowmy]

@Akshaykadam98 

Share sample data and the ecpected results with some examples. Create a dummy PBI file and share using Google Drive, paste the link here.