Forum Discussion
Akshaykadam98
2 years agoRegular Visitor
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
- FowmySuper User
Akshaykadam98
Currently, automatic selection of slicer value is not possible. Please redefine your approach.- Akshaykadam98Regular Visitor
- So what should I create if I have to show latest 5 weeks data, my weeks column is in text data type
- FowmySuper 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.