Not showing data in slicer if corresponds to empty results

[Zyg_D]

This is my data: 

And the report view (slicer + table): 

(the slicer is based on Table2[category])

The question: is there a way not to show "112" in the slicer if I do not have corresponding data in the related Table1? 
This is very simplified data, so I need an answer which will not include these: 
- creating a slicer based on Table1[category]
- explicitly filtering out "112" in filters pane

[amitchandak · Accepted solution]

@Zyg_D , Create a measure in your fact .

M1= count(Table1[Category])

And put that into the visual level filter of Category from Table2 , check M1 is not blank

You can this video if needed, this for 2 slicers, but the logic is same - https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Zyg_D · Accepted solution]

A filter + measure count(Table1[Category]) really works - thanks, @amitchandak. 

Also, I was able to find my own solution, using only a filter based on Table1[sub_cat]) 

[Anonymous]

The Show items with no data feature enables you to do exactly that - include data rows and columns that don't contain measure data (blank measure values).

To enable the Show items with no data feature select a visual, then in the Fields well, right-click the field and select Show items with no data from the menu that appears.

The Show items with no data feature does not have effect in the following circumstances:

• There's no measure added to the visual, and the grouping columns come from the same table
• Groups are unrelated; Power BI doesn't run queries for visuals that have unrelated groups
• The measure is unrelated to any of the groups; this is because the measure will never be blank for only some group combinations
• There's a user-defined measure filter that excludes blank measures - for example: SalesAmount > 0

[sreenub]

create bi-directional model relationships

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering

[amitchandak · Accepted solution]

@Zyg_D , Create a measure in your fact .

M1= count(Table1[Category])

And put that into the visual level filter of Category from Table2 , check M1 is not blank

You can this video if needed, this for 2 slicers, but the logic is same - https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values