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 all,
I currently use Power BI connected to a sharepoint online list that users use to capture case information. Cases have 3 status - New, Open & Closed
I am looking to build a visuale table in Power BI to show me all cases that are open for more than 35 days?
Any suggestions/tips would be greatly appreciated!
Solved! Go to Solution.
Hi @AlanB34 ,
I use this table for testing.
Please new a measure.
Measure = IF(DATEDIFF(MAX('Table'[Case creation time]),TODAY(),DAY)>35,1)
Setting of the filter.
Attached PBIX file for reference.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @AlanB34 ,
I use this table for testing.
Please new a measure.
Measure = IF(DATEDIFF(MAX('Table'[Case creation time]),TODAY(),DAY)>35,1)
Setting of the filter.
Attached PBIX file for reference.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
You may create a measure such as
Days Open=
CALCULATE(
DATEDIFF(Today(), Table[Creation Date],DAY),
KEEPFILTERS(Table[Status] = "Open")
)
Next, you can add this measure as a filter on the visual (is greater than 35).
This returns the
Right, that's an issue.
The easiest way around it would be to create a duration column for us to work with (if the status is open), either in PowerQuery or- if possible- at the source (for example, a SQL view).
Now you can just put this field in the filter pane with "greater than 35".
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |