Need a help on Matrix visualization blank

[aknewbie]

I have a timesheet data where it has multiple entries of different dates and project for each employee with the status as Approved, Submitted, never submitted/not submitted. I would need to group the dates as weeks, where if an employee submit for a day in a week is also considered as "Submitted / Approved".

I have created a calendar table with all the dates. I need an output in Matrix Visualization, where it needs to show the blank entries as "No entry" and also need to compare the Hiredate with Timesheet date and leave the weeks prior joining week as blank.

Thank you in advance.

[v-jianboli-msft]

Hi @aknewbie ,

You said that: 

it needs to show the blank entries as "No entry"

What are the blank entries? Besides, what is joining week?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.