Forum Discussion
Helper IIITime groups in filter or slicer with same weeks in multiple groups
My data is broken down by week and I would like to create one filter/slicer for time groups, such as last 4 weeks and last 13 weeks. I'm not sure how to do this because the last 13 weeks includes the last 4 weeks and I cannot figure out how to include the same weeks in multiple groups. Is this possible?
Yes this is possible but will require you to create a new What If Parameter in the Modelling tab;
This will create a new table with possible values of your parameter. In you measures, you can check the value by using SELECTEDVALUE(ParameterName[ParameterName]) and evaluate your measure 🙂
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
1 Reply
- JarroVGIT
Resident Rockstar
Yes this is possible but will require you to create a new What If Parameter in the Modelling tab;
This will create a new table with possible values of your parameter. In you measures, you can check the value by using SELECTEDVALUE(ParameterName[ParameterName]) and evaluate your measure 🙂
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂