Make a list of stores permanent even though they show cero

[Anonymous]

Hi,

I have a report which count with information of various stores.

I need to add a button or a slicer where the stores show even though on the database of that specific month does not come with information of all the stores, in other words, if there is no information about a certain store the report should show no information, but the option of selecting that store should be always available.

I hope you can help me.

Cheers!

[lbendlin · Accepted solution]

@Anonymous enable the "Show items with no data" setting for that column in the slicer, or use a disconnected table to feed the slicer.

[Anonymous]

Hi!,

Can you show the procedure with an example dashboard?. 

I will be waiting for your response.

Cheers!.

[lbendlin]

Yes, if you provide sample data  ( a table with stores and a  table with sales for example)

[Anonymous]

Hi,

Of course. I have attached a sample table: 

https://gofile.io/d/GepYwh

I hope you can help me.

Cheers!

[lbendlin]

Here's an example using a dimension table.  You can modify as needed.

That's a lot of cucumbers!