topic Re: Visual Chart from missing inputs in the table in Custom Visuals Development Discussion

Visual Chart from missing inputs in the table

rodrigues_ear — Tue, 04 Mar 2025 21:46:51 GMT

Hi,

I have a scenario that seems simple but has been challenging for me.

I manage multiple systems/servers that send log data to a SQL database to indicate they are ON. I import this data into Power BI to track their status over time—by date, month, etc.

To represent this setup, I created two tables:

A Date table containing all dates of the year.
A Logs table storing system/server logs.

These tables are linked by date.

I can analyze the data to show when the systems are ON by counting the "ON" status from the STATUS column. However, the issue is that no data is logged when a system is OFF (e.g., on Jan 2, 2025, System #2 is OFF, so no entry is recorded):

I'm not sure how to do it, but I need to identify when a system was OFF—essentially, when the count of "ON" entries is missing or differs from expectations. This is what I need:

How can I do that!?

Re: Visual Chart from missing inputs in the table

lbendlin — Sat, 08 Mar 2025 02:29:30 GMT

To report on things that are not there you need to use disconnected tables and/or crossjoins

Re: Visual Chart from missing inputs in the table

rodrigues_ear — Mon, 10 Mar 2025 23:01:36 GMT

Could you please share how to do that?

Re: Visual Chart from missing inputs in the table

lbendlin — Mon, 10 Mar 2025 23:34:30 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523