Only show present values in slicer

[mrvega]

Hi,

I have two tables with a relationshiop linked by SiteID.

When I build a slicer using SiteDescription, I ONLY want to see Website1, Website2 and Website3 (ie. values that have data). I have tried setting the relationship's cross-filter direction to 'Both', but I still see all SiteDescriptions appearing in the slicer. 

SiteID	Value
1	#
2	#
3	#

SiteID	SiteDescription
1	Wesbite1
2	Wesbite2
3	Wesbite3
4	Wesbite4
5	Wesbite5

Can anyone help?

Thanks

[V-lianl-msft · Accepted solution]

Hi @mrvega,

You could set the two table relationship to "1-*" (SiteID 1, 2, 3 as "*") and use the DAX below:

Column = RELATED('Table (2)'[SiteDiscription])

Use this calculated column as a slicer

Best Regards,

Liang 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.