Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Values not seen as in Query Editor and Data View.

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

  • 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.

  • 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.
  • 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.

4 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional

    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.

  • 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's avatar
    V-lianl-msft
    Community Support
    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's avatar
      Anonymous
      Not applicable

      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