Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am currently having the issue that my Earned % Complete and Planned % Complete is not being filtered by the Reporting Period slicer. It is showing an overall percentage instead of the fortnight percentage.
Is there a measure that allows me to just filter the earned/planned data between the fortnight date period? Or a special way of doing it haha.
Thank you
@Dylo_Bloomfield , there are a few ways, You can use an independent date table
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
Hello @amitchandak
Thank you for the help!
I am still a bit stuck on the measure... I currently have made the below but have come to an error.
I have linked the PS 3 and Calendar (Milestone Source) tables, but I am just trying to show the earned % complete for the fortnight between 01/07/2023 and 14/07/2023. I tried applying filters but they do not work on the visual (I don't know why). Hope this makes sense and Thank you friend.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |