Forum Discussion

reshefy's avatar
reshefy
New Member
2 years ago
Solved

Create a table visual showing items with no data

Assume that I have a list of doors, and I assign a unique name to each door – I will call the list of doors my inventory.   Each door has a sensor that registers the time someone passed through the...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from Greg_Deckler , please allow me to provide another insight:

    Hi, reshefy 

    Regarding the issue you raised, my solution is as follows:

    1.First I have created the following table and the column names and data are the data you have given:

    2.Create calculated table references:

    Table2 = 
VAR T2 =
    SELECTCOLUMNS ( 'Table', "Value", LEFT ( 'Table'[information], 5 ) )
VAR T3 = { "Door1", "Door2", "Door3", "Door4" }
RETURN
    EXCEPT ( T3, T2 )

    3.Here's my final result, which I hope meets your requirements.

    Please find the attached pbix relevant to the case.

     

    Best Regards,

    Leroy Lu

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


     

reshefy's avatar
reshefy
New Member
2 years ago

Thank you for the solutions. Maybe I was not clear enough in my posting - I appologize for that.

For the sample data that I provided, I would like to show the folloing table:

 

Door  | number of events

----------------------------

Door1 | 3

Door2 | 4

Door3 | 0 (or blank if it is easier)

Door4 | 2

 

I would also like the be able to add a date slicer, do when I select a date range, only the events during that date range will be counted (i.e., if my sample data had data from 8/6/24 and I select just 8/6, only 8/6 data will show, but the table wil lstill list the four doors, regardless how many of them triggered an event.

Thank you,

Yaron