Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Slicer that dynamically adapts its range based on the matrix selection

Hi,   can you please help to understand how to implement in the example below a slicer that dynamically adapts its range as soon as one or multiple row values in the first matrix (m1) are selected....
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  Anonymous  ,

    1. First, the slicer with value as the filter is used to limit the value values of M1 and M2. At this time, M1 and M2 will only display data in the restricted area of 8-15

    2. Select the date in the week field through M1 of the restricted value, and apply it to m2

    3. At this time, M2 is limited by both the slicer and the value of M1

     

    I think you can replace M1 with slicer, which will make the display more intuitive and the effect is the same

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  Anonymous  ,

1. First, the slicer with value as the filter is used to limit the value values of M1 and M2. At this time, M1 and M2 will only display data in the restricted area of 8-15

2. Select the date in the week field through M1 of the restricted value, and apply it to m2

3. At this time, M2 is limited by both the slicer and the value of M1

 

I think you can replace M1 with slicer, which will make the display more intuitive and the effect is the same

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.