topic Re: Show overtime as greater than 100% in DAX Commands and Tips

Show overtime as greater than 100%

mcumis — Mon, 08 Jul 2024 11:23:57 GMT

I have a calculation which shows hours recorded in payroll excluding overtime, this is divided into groups to show who was training, on leave, sick etc. And it's in a stacked 100% chart:

What I want to do is show this same chart but with an additional bar above where overtime is a value above 100%, i.e. the 100% is made up of what isn't overtime, then 100-109% is overtime.

Any ideas?

Re: Show overtime as greater than 100%

foodd — Mon, 08 Jul 2024 11:34:31 GMT

Hello mcumis , and thank you for sharing a question with the Community. Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Re: Show overtime as greater than 100%

Anonymous — Thu, 18 Jul 2024 02:36:42 GMT

Hi, mcumis

Thanks for foodd reply. Unfortunately the current version of Power BI desktop does not support the functionality you describe beyond the 100% bar chart to show overtime percentages. Perhaps you could try the Stacked column chart.

You can submit an idea for here and the product team will take note of such a need.