Late reporting visualisation

[Anonymous]

Hi guys,

I am trying to visualise late reporting in my dashboard. My dashboard will be updated weekly. 

Ideally, I would have 'Hospital name' (e.g. 'Hospital A' 'Hospital B' and so on) on the x-axis, and week number on the y-axis. 

So assuming I was to publish my dashboard on Wednesday (after all data validation and checks), I'd expect all hospitals to deliver their latest data extract on Monday. If I did not get the data delivery this week (the latest available would be last week's), I'd like to visualize this on my dashboard in colour like red/orange in the form of a bubble/tile for each corresponding hospital. 

I tried downloading the Data visuals from Power BI Visuals marketplace, but none of them seem to work for what I want to show. 

Does anyone have an idea on how to do this?

Thank you!

[Anonymous]

Hi @Anonymous ,

It's hard to understand what kind of visual you want only by words description. Please show some sample data and expected result to us.

Best Regards,

Jay

[parry2k]

@Anonymous I have written a blog post on delaying the month-end reporting, you can check the post here and tweak the solution as per your need.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡