Values not seen as in Query Editor and Data View.

[Anonymous]

Hi,

I have a flag column with values Y and N in my data source. When I pull in the data, I see both the values Y and N in the query editor as well as the data view.

However, when I drag the Flag column in my filters or a table view, I only see value N. I do not see Y. No other filters are applied.

This is really weird. Please help with this.

Thanks,

Vishy

[mwegener · Accepted solution]

Hi @Anonymous ,

could you share your pbix file?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Tahreem24 · Accepted solution]

Sounds weird. But can you check once is there any page or visual level filter applied?

Please share some insights on it for better resolution.

Please give Thumbs up and mark it as a solution if it helps you.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, i can't reproduce your problem. You could creat a support ticket with your problem or share your sample pbix file(Please mask any sensitive data before uploading).

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

[Anonymous]

Hi,

It's working fine now. There was a hidden page and filter due to which it was happening. 

Sorry for the premature concern, I did not know that the previous person who consumed the report added a hidden page and filter, will be mindful of this going forward.

Regards,

Vishy

[Tahreem24 · Accepted solution]

Sounds weird. But can you check once is there any page or visual level filter applied?

Please share some insights on it for better resolution.

Please give Thumbs up and mark it as a solution if it helps you.

[mwegener · Accepted solution]

Hi @Anonymous ,

could you share your pbix file?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.