Creating One Slicer that Combines Two Identical Lookup Tables

[Anonymous]

Hi All, 

I have an issue with my project where I need to use one slicer to filter all visuals based on "Topic". The problem is that ther are two "Topic" columns (Topic1 and Topic2) in each fact table, containing identical values. (I cannot change the way this is setup unfortunately)

These two "Topic" columns(Topic1 and Topic2) each have their own lookup tables, which is where the need for using one slicer is coming from, as I would like to see data filtered for all strings that might contain valueX in either Topic1 or Topic 2 columns. 

Please see the data relationships below. Any and all suggestions are welcome!

Is it possible to combine the lookup tables for "Topic1" and "Topic2" in order

[Icey]

Hi @Anonymous ,

Is this problem sloved?

If it is sloved, could you kindly accept it as a solution to close this case?  

If not, please let me know.  

Best Regards

Icey

[Icey · Accepted solution]

Hi @Anonymous ,

You can use Union to combine Topic 1 and Topic 2 to one column.

Best Regards,

Icey

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