Forum Discussion

PSampras's avatar
PSampras
Frequent Visitor
4 years ago
Solved

Use slicer value to filter a table

Hy everyone, this is my first post here šŸ˜ƒ I hope to write it in the right way   This is my problem. I have a simple "Table 1 - Fatturato"     I want to create an other table "Table 2 - ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi PSampras ,

     

    To my knowledge, calculated table could not be dynamically changed via slicer.

     

    If you want to dynamically filter a table... Iā€˜d suggest you put the columns into a table visual and create a measure that will return 1 for the rows you want to see and 0 for those that you don't. Then use the Visual-level Filter Pane to filter the rows by the measure. For example:

    Flag Filter = IF(YEAR(MAX('Fatturato'[DatDoc]))=SELECTEDVALUE('Year Selection'[Year]) && MONTH(MAX('Fatturato'[DatDoc]))<=SELECTEDVALUE('Month Selection'[Month]),1,0)

     

    Best Regards,
    Eyelyn Qin
    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
4 years ago

Hi PSampras ,

 

To my knowledge, calculated table could not be dynamically changed via slicer.

 

If you want to dynamically filter a table... Iā€˜d suggest you put the columns into a table visual and create a measure that will return 1 for the rows you want to see and 0 for those that you don't. Then use the Visual-level Filter Pane to filter the rows by the measure. For example:

Flag Filter = IF(YEAR(MAX('Fatturato'[DatDoc]))=SELECTEDVALUE('Year Selection'[Year]) && MONTH(MAX('Fatturato'[DatDoc]))<=SELECTEDVALUE('Month Selection'[Month]),1,0)

 

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

PSampras's avatar
PSampras
Frequent Visitor
4 years ago

Thank you Anonymous , it works!