Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Display percentage of cycle counted locations dynamically with the help of a date slicer

Hello folks,


I am supposed to track percentage of cycle counted and non-counted locations in a warehouse with the help of a date slicer. CommunityHelp.PNG





It is working fine if I simply refresh and don't touch the date slicer. But if I try to play with the date slicer, it shows weird percentages as shown below in the figure.



The cycle count is performed twice in a fiscal year where I work. So, ideally, the count percentage should reach 100% near end of first half of this present fiscal year (31 December 2022) and vice versa for uncounted percent.

Please help. Thanks in advance!

Super User
Super User

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors