Slicer showing all options until data appears in the tables

[ACraig08]

Hello, I am more just wondering if this is possible. I have a page with three tables on it and one of the values in the table is District. The tables have quarterly filters on them so there won't be any data in them until we have entered that quarter and certain criteria is met. Until that happens my District button slicer is empty and so it just looks like a giant empty space on the page.

I was wondering if it is possible to have it show all of the values in the District column until data starts to appear in the tables, then it only shows the districts listed in the tables. Or even if there is a way to change the background color of the ones that are available vs not available. 

So below is an example of what happens now when data starts to appear in the tables:

Districts D1, D2 and D8 show up on the other tables in the visual.

I created a table called AllDistricts that I used in the slicer and created a connection between that table and my primary Project Data table so now this shows up and it can filter the tables.

I just don't know if that is the right approach or even what to do next.

[Bmejia · Accepted solution]

Hi,

I believe you are on the right track, so you created a table AllDistricts to show all the Districst in you slicers, which I believe accomplishes what you are looking to see.  If you need to have the slicers change color when there are no values add a conditional formating to the slicer

Example: Created a measure that add a value, so find a value that you can create the logic you need.

[ACraig08]

Oh brilliant! I used the District field from the primary table to add conditional formatting to both the background color and text color so they look unavailable!

Thank you so much!!