Forum Discussion
Filter Table depending on value from a Donuts charts
- 9 years ago
In this scenario, when you click in the Donut, only the category you selected will be applied as fitler on other visuals. So your table visual will only be filtered with "OPEN", it can never determine you click it from the "Overdue" or "Next 7 days" charts. The "Next 7 days" filter only works within your measure.
For your requirement, you should add a column to tag if the date in current row is within "Next 7 days".
Date Range = IF ( ( Table[Finish Until] - TODAY () ) <= 0, "UP TO TODAY", IF ( ( Table[Finish Until] - TODAY () ) > 0 && ( Table[Finish Until] - TODAY () ) <= 7, "NEXT 7 DAYS", "OTHER" ) )Then you can populate above colum into a slicer to filter the Donut and Table visual.
Regards,,
In this scenario, when you click in the Donut, only the category you selected will be applied as fitler on other visuals. So your table visual will only be filtered with "OPEN", it can never determine you click it from the "Overdue" or "Next 7 days" charts. The "Next 7 days" filter only works within your measure.
For your requirement, you should add a column to tag if the date in current row is within "Next 7 days".
Date Range =
IF (
( Table[Finish Until] - TODAY () )
<= 0,
"UP TO TODAY",
IF (
( Table[Finish Until] - TODAY () )
> 0
&& ( Table[Finish Until] - TODAY () )
<= 7,
"NEXT 7 DAYS",
"OTHER"
)
)
Then you can populate above colum into a slicer to filter the Donut and Table visual.
Regards,,
- newphoto9 years agoRegular Visitor
Thanks a lot. Your help is very much appreciated!