Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
84 | |
70 |