Slicer doesn't show all data from sql view

[Anonymous]

My report contains an slicer which reads from an sql view. List of all products is in this view and also I've added a row :<Select product> which is the default value for slicer. But Slicer in report dosn't show <Select product>. Could someone help me if I missing something in design or report setting so that I get this default value in slicer?

[amitchandak]

@Anonymous , how you added this row, and is this data visible in the table in data view ?

[Anonymous]

Thank you @HotChilli and @amitchandak  for your reply.

Yes, I've created an sql view and inserted all value manually for product into it and also a row for <Select Product>. In report I sort slicer 'Z-A' and <Select product> would be always as default value(as first option) in slicer.

When I run a select query <Select Product> is visible in result but not in slicer.

I think the problem is not the way I created sql view but there is something in report or report setting that should be changed and I don't know what or where.

[HotChilli]

Can you post the pbix?

[Anonymous]

@HotChilli 

Unfortunatly I'm not permitted to do it and there is nothing speciall with this slicer or report either. If I remove the name and other information in report it remains a very simple slicer and result table.

What you need to check in report specifically so I send it ?

[v-easonf-msft]

Hi , @Anonymous 

Still not very clear. Can you explain bit more?

How did you  create the slicer with the  default value <Select product>  ?
Related screenshoots will make it easier for us to understand and  solve your problem.

Best Regards,
Community Support Team _ Eason

[HotChilli]

I think we'll have to see the pbix.

You'll be using a view to populate a query (and adding text for <Select Product> manually ?)

If you add the column to a table visual, you should be able to see if Powerbi has updated the query correctly.