Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
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
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |