Simple filter not reflected

[zanottiluca]

Dear gurus,
I am fairly new to PBI. I have this "issue" that simply I cannot absorb, and I would like to have a logic anwser. 

I have two simple table "Clients" and Country having key the CountryCode. Now I create a simple bar chart visual just combining a Count of Client by CountryName (in the table Country).

In the Edit query I filter by CountryCode excluding a couple of country. Now i have two doubts: why in the visual i see "blank" in the Axis alongside the unfiltered country. And secondly why i still see all data of the Clients table while rightly i do not see on the Country?

I understand the ideal would be to filter both, but this is messing a bit my understanding of cross filtering, relationship etc so I am begging you to provide a logic question in order to resolve this little issue (even a link with a good logic explanation would suffice).

Thanks

Luca 

[Ashish_Mathur]

Hi,

Share your PBI file with the visual already built in there.

[zanottiluca]

Hi again and apologies for the delay. Below there is my folder link with the pbix and source folder.

https://1drv.ms/f/s!AjU3fZfEMvkyhZxZadtXP2a_-BmS4g

As stated before I would like to undersatnd why the filter is not propagated to the visual, as i would expect. I am asking for a logic explanation in order to undersatnd this basic pricnciple (ex is it due because is a MANY to 1 and the filter is in the 1 side?). Consider also that I may encounter situations where I have more than one query linked and I would like to create correct visual combining different fields coming from different query. Is the best behaviour Merging the queries incorporating the field and filtering on each query? (in few words propagating the field across different query linked together?) 

Thanks in advance

Luca 

[Ashish_Mathur · Accepted solution]

Hi,

There is nothing wrong in what you have done.  All i can suggest is that instead of dragging the Client Name from the Clients Table to the value section of the visual, write this measure

=COUNTA(Clients[ClientName])

Now, as regards your question, the reason you see Blank in the visual is that NZ is not listed in your Countries Table.  Since the Countries Table is the master table, it should contint a list of all countries (even those that are not in your Cleints list).  The moment you do that, Blanks will be replace with New Zealand.

[Anonymous]

Based on what i can quickly see.  Does your country table have every possible country code that might be contained in your Client data?  Based on the bar chart, the (Blank) indicates to me that all of those clients are unable to be linked to your country table some how.

If that was intentional, what you need to do is set up a page level filter that hides any of those blanks.

[zanottiluca]

HiRoss73312,
Thanks for your email. My doubt is not on how to achieve the goal by hiding the blank. Is why this is happening. The country table contains just US NZ UK AUS and also the client table contains only those values. Countrycode is the key for the relationship.And I have filtered excluding US and UK.
I would have expect to do not see the blanks after the filter action on the Country table.
As you said somehow the client contains those values anyway but why? Is due to the fact that is a one to many? The or is the visual that is wrong? And why the Data menu still show those values for clients even if they are related?
Thanks
Luca

[Anonymous]

Without seeing the data its hard to know specifically, but typically it indicates that however your table structure is set up, those records are not achieving a match.