showing people with 0 inspections

[easton16]

Hi All,

I am currently trying to display a count of inspections carried out by users, filtered by period in a table visual. I have achieved this, however, cannot work out how to show users who haven't carried out any? I have a list of users compiled already?

Thanks in advance for any pointers.

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output.

@easton16 ,

Try showing the rows without data. and put a visual level filter for blank

Appreciate your Kudos.

[easton16]

Thanks,

I have tried this, but unfortunately it has not worked. I have added more detail to the thread with what I am trying to do, before I applied any of my current quires.

[az38]

@easton16 

it's impossible to give you correct and full answer without data example, but you can try to set active option "Show items with no data" in you visual fields settings

[easton16]

Hi @Anonymous 

This is One Table with some sample data and the other table is just a list of inspectors. At the moment the visual is just a table showing Inspector and count of ID, however I want to include all the inspectors in it?

Does this make a bit more sense what I am trying to achieve?

ID

Group

Auditee

Title

Inspection Template

Inspector

Inspector Email

Team Members

Planned Date

Due Date

Completed Date

Person Involved

Actual Start

Findings

Actions

Ref

Score

Status

Budget

Sync Status

Risk

Category

Type

Severity

Age

Planned / Unplanned Event?

Period

2020032

Maintenance

Location 1

Site Assurance Checks Form 18Mar2020

Site Assurance Checksv4 Form

Bob

xxx

18 Mar 2020

18 Mar 2020

18 Mar 2020

########

0/0

0/0

0

Complete

1

Planned

12

2020038

Maintenance

Location 2

Vehicle Inspection 18Mar2020

Vehicle Inspection

John

xxx

18 Mar 2020

18 Mar 2020

18 Mar 2020

########

0/0

0/0

0

Complete

1

Planned

13

2020039

Maintenance

Location 2

PPE - Task Specific 18Mar2020

PPE - Task Specific

Gill

xxx

18 Mar 2020

18 Mar 2020

18 Mar 2020

########

0/0

0/0

0

Complete

1

Planned

13

Inspector

Bob

Gill

John

Mark

Dave

Beth

[az38]

@easton16 

add your Inspectors from inspector table on visual

then add ID field onto the same visual

then make sure your tables have relationships

then set "Show items with no data" for Inspector field in visual

[easton16]

thanks @az38 

I have done this, however it is showing all the inspectors with the count column as blank then one row of the inspectors as blank with the count total showing. I have tried all the different types of relationships with no avail?

[az38]

@easton16 

show us screenshot or share pbix-file to Cloud

[easton16]

@az38 Here's a screenshot of how its displaying,

 

[az38]

@easton16 

it looks like inspectors names are different in both tables.

Maybe you need to execute trim operation for fields with inspectors names in Power Query Editor

Make sure the names are the same