Show items with no data - not working on Table

[AvPowerBI]

Hi,

I currently have two tables

EngineerCalendar

Visits

Joining the two tables using Cross filter Selection - Single

Not eveything will exist in the Visits Table, so when I created a Table with the following values

Engineer ID (Table: EngineerCalendar)

First Name (Table: EngineerCalendar)

Call No       (Table: Visits)

I get to see the values I want to see 

But if change the Values around swapping the First Name and Call No, I see the below which is not correct, as I should be seeing the First  Name?

Does anyone know if this is a Bug in Power BI?

I have set the following on each Value Show items with no data

I basically need certains Values to be in a specific order.

Thanks

[AllisonKennedy · Accepted solution]

See this article for help:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

As it says near the bottom, Power BI treats Show Items with no data as a Left Outer Join:

Notice how (Gloss-Red) and (None, blank) appeared as combinations. Here is the reason they appeared:

Power BI first considered ProductStyle[Finish] and selected all the values to display - this resulted in Gloss, Matte, None.
Using each of these values, Power BI selected all the corresponding Product[Color] entries
Since None does not correspond to any Product[Color], a blank appears for that value
It's important to note that the mechanism of selecting values for the columns is order-dependent, and can be thought of as a Left outer join operation between tables. If the order of the columns is changed, the results will change as well.

Let's look at an example of changing the order, and how it impacts results. This is the same as item 2 in this section, with the ordering changed.

[AllisonKennedy]

Have you set them all to Don't summarize as well? Otherwise your name might be trying to do a 'First' instead, giving you the error?

Also, because of the cross filter direction, if Andrew has no Call value, then you won't see his name in the Name when it is placed after Call. 

@AvPowerBI  

[AvPowerBI]

Hi @AllisonKennedy 

Thanks for your reply.

Yes all the fields are set to Don't summarize.

Not sure what you mean when you have said:

"Also, because of the cross filter direction, if Andrew has no Call value, then you won't see his name in the Name when it is placed after Call. "

Yes for that particular day which I have a filter on Dates from the EngineerCalendar 

EngYear = 2020

EngMonth = July

EngDay = 17

Andrew did not make any calls for that day but I still want to show the end users that row on the table,

I just find it strange that based on the position of the Values it shows a value but rearrage them it does not show the value.

Thanks

[AllisonKennedy · Accepted solution]

See this article for help:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

As it says near the bottom, Power BI treats Show Items with no data as a Left Outer Join:

Notice how (Gloss-Red) and (None, blank) appeared as combinations. Here is the reason they appeared:

Power BI first considered ProductStyle[Finish] and selected all the values to display - this resulted in Gloss, Matte, None.
Using each of these values, Power BI selected all the corresponding Product[Color] entries
Since None does not correspond to any Product[Color], a blank appears for that value
It's important to note that the mechanism of selecting values for the columns is order-dependent, and can be thought of as a Left outer join operation between tables. If the order of the columns is changed, the results will change as well.

Let's look at an example of changing the order, and how it impacts results. This is the same as item 2 in this section, with the ordering changed.

[AvPowerBI · Accepted solution]

Thanks @AllisonKennedy so I need to make sure all the fields in the Table that relate to Visits need to appear first and fields from EngineerCalendar to appear after them

[AvPowerBI]

Anyone have an answer for this?