Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Late reporting visualisation

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!

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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