PowerBi Report Modification and Optimization

Job ID: 31107834

Budget: $250 – $750 USD

I am not a PowerBi expert but have built several reports, but they need to be optimized. In the sample report that is attached, under "Past Due Items By Company", I would like to be able to add more than one person's name for each of the items. I do not know how to do this. Under "Issues by Level", I would like it to automatically add data with tags that meet a certain requirement, such as starting with the word "Zone" "L" followed by a number or "UDG". I have to edit the query to manually change this now.

I would like new visuals similar to "Past Due Items By Company", but want the data to show the "average number of days for each company to close an item". The data set shows dates when the issue was created and when it was closed. Not all items in the data set have a closed date. If they don't have a closed date, they should be ignored.

Lastly, want all the code or whatever to be optimized so that it runs better.

When you respond with interest in assisting me. Please start your response with "Happy New Year". If you do not add that, I will know you did not read everything in the description of the project and I will ignore your chat.

Thanks.
Related categories: Power BI