Help with Calendar and Gauge Viz

[HTS]

Hi!

I am fairly new to PowerBi an dI am wondering how to achieve the following. 

Lets say hipothetically that we have a database that needs to be backedup every day.  column A has name of DB and Column B has date of Last Backup.

I want to create a Calendar showing green the days that the db was backup. So if we have DB1 and it has been backeup up every day since march, I want all days to be filled with green. The caveat to this is that I have multiple DBs and Sometimes they span years. How to I do this? I tried using the calendar custom viz, but it didnt work too well for me since it is only measuring one thing through time and not multiple things.

Also, with that same data lets say I want to create a card showing the numbers of days since the db was last backep up. My goal is 1, however if a DB hasnt been backeup up for 5 days, I dont want the mark to show that we have exceeded the goal, instead I want to say that we are below our target. 

Thank you!

[v-yuezhe-msft]

@HTS,

Could you please share sample data of your table and post expected result in table?


Reagrds,
Lydia

[HTS]

Absolutely!

This is what my base data looks like: 

This is what I want the end result to look like :

With the cells matching the status.

This is my relationship model:

Thank you!

[v-yuezhe-msft]

@HTS,

There are no built-in Power BI visuals or existing custom visuals that could be used to display your expected result. You would need to create your own custom visual to show the end result.

Regards,