Show overtime as greater than 100%

[mcumis]

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?

[Anonymous]

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.

Related Link: New tab (powerbi.com)

Best Regards,
Yang
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 in the Power BI Forum

[foodd]

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-...

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/1447...

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