Remove information from uploaded dataset

[irnm8dn]

I have a static dataset representing 3 products.  I would like to remove 1 of the 3 products from view/use by the dashboard users.

i.e. Apples, Oranges, Bananas

Using a filter will not allow me do this in an appropriate way.  How can "comment out" all of the information for the specific product.  i.e. I don't want the users to see Bananas on the report...as if Bananas, and any Banana related data didn't exist.

Thanks in advance.

[v-ljerr-msft · Accepted solution]

Hi @irnm8dn,

If I understand you correctly, you can filter your Product column in Query Editor to select the product you want to load into the data mode in this scenario. 

Regards

[irnm8dn]

Works great!

Thanks.