Forum Discussion

newphoto's avatar
newphoto
Regular Visitor
9 years ago
Solved

Filter Table depending on value from a Donuts charts

I have spent an hour finding a solution for my problem,  but not getting there.... I have my report:                                        When i choose for example 'Open'...
  • v-sihou-msft's avatar
    9 years ago

    newphoto

     

    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,,