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' from 'Overdue Tickets' Charts, i want to see in table just the value where 'Finish until' date is smaller as today.

 

When i choose 'Open' from  'Next 7 Days Tickets' Chart, i want to see in the table just value with 'Finish until' date  between tomorrow and tomorrow+7 Days. 

For the charts i created two measures where i use Filter function to select just the values with the desired date.

But i don't know how to filter the table depending on the date from my Charts.

Any ideas?

Thank a lot

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    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,,

3 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    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,,

    • newphoto's avatar
      newphoto
      Regular Visitor
      9 years ago

      Thanks a lot. Your help is very much appreciated!