Forum Discussion

Amyries's avatar
Amyries
Helper I
10 months ago
Solved

How to Automatically Reset Slicer Selections When Changing value in Slicer in Power BI?

Hi everyone, I have a question regarding Power BI slicer behavior: Initially, I select SprintKey = "199_S1" and choose Week 1 (2025/02/10) and Week 31 (2025/09/01) in (2.1), (3.1) slicers. ...
Need Help
Tips and Tricks
  • Amyries's avatar
    Amyries
    10 months ago

    v-achippaThe issue is not resolved yet, and I might have to tell my client that it’s a limitation of the tool.

Amyries's avatar
Amyries
Helper I
10 months ago

Thank you for your detailed responses!
However, I am wondering: if SprintKey is increases, does that mean I need to manually create the corresponding 週 (number) in From_EVM_Dates and To_EVM_Dates?

OwenAuger's avatar
OwenAuger
Super User
10 months ago

Amyries Good point! The need for a potentially growing set of copies of these columns is the main drawback with this method.

 

I consider this method a workaround and certainly not good modelling practice. Model table schemas should generally not change over time.

 

I would only recommending using this method if you can automate the additional columns in Power Query or further upstream. I wouldn't recommend adding these columns via DAX in practice.

 

Also, it may not be desirable to use this method  if the number of SprintKey values becomes particular large.