Forum Discussion

Akshaykadam98's avatar
Akshaykadam98
Regular Visitor
2 years ago

undefined

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 

3 Replies

  • Akshaykadam98 

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

    • Akshaykadam98's avatar
      Akshaykadam98
      Regular Visitor
      • So what should I create if I have to show latest 5 weeks data, my weeks column is in text data type
      • Fowmy's avatar
        Fowmy
        Super User

        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.