Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Backlog tickets

Hi

I am creating dashboard for our department ,

I want to present the backlog tickets in 2 different chart .

1st chart : tickets the created  < 4 days   - for this chart I did it using filter pane

2nd chart : ticket the created   >= 4 days   -  need your support 😊

 

pbix file in below link

https://drive.google.com/file/d/16V5VjACKXAJHL7IzLj9R9WKfnsPxfcM4/view?usp=sharing 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi , Anonymous 

    In your sample , I found that 1st chart :tickets the created <4 days , you are using a relative date filter pane to achieve it.

    In fact ,you can create a calculated  column 'Today-SubmitDate' :

     

     

    Today-SubmitDate = DATEDIFF(Sheet1[Submit Date],TODAY(),DAY)

     

     

    Then apply 'Today-SubmitDate' to filter pane  to filter this visual as below:

    1st chart : tickets the created  < 10 days  :


    2nd chart : ticket the created   >= 10 days

    Please check my sample file for more details.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Anonymous ,

     

    You can create a table or matrix with the two categories:

    1) <4 days

    2) >=4 days

    Now create two measures to get the corresponding values. The code would look something like below:

    1) For <4:

     

     

    DelayedTickets = 
VAR TimeFrame = 4
VAR backlog =
    COUNTROWS (
        FILTER (
            'YourTable',
            IF ( 'YourTable'[YourColumn]
                 < TimeFrame,
                1,
                0
            )
        )
    )
RETURN
    backlog

     

     

    Similarly for >=4 days

     

    I hope this will suffice your requirement

     

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi , Anonymous 

    In your sample , I found that 1st chart :tickets the created <4 days , you are using a relative date filter pane to achieve it.

    In fact ,you can create a calculated  column 'Today-SubmitDate' :

     

     

    Today-SubmitDate = DATEDIFF(Sheet1[Submit Date],TODAY(),DAY)

     

     

    Then apply 'Today-SubmitDate' to filter pane  to filter this visual as below:

    1st chart : tickets the created  < 10 days  :


    2nd chart : ticket the created   >= 10 days

    Please check my sample file for more details.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.