category slicer

[SCallanan]

@ahadkarimi 

Which is the best way to combine categories from different tables.

The scenario is the following:

I have 3 tables from 3 different years. All have the same column headers. I have a column called Ports and want to build a slicer which can select the respective port on any given date within the range.

I was thinking of using a parameter, but it only shows the column header and not the column content. Obviously, I want to select the level below. I have done this plenty of times with numeric measures, but suddenly seem to be a bit lost with the categories.

Also, I thought there was a way to merge these columns in a separate table within Power Query, but I can’t exactly remember how. Would that be better?

Thanks again, Sandra

[mark_endicott · Accepted solution]

@SCallanan - These 3 tables should be appended in Power Query rather than trying to handle this in DAX, it will be much easier, optimal and better for your model. 

Please see the guidance on this here: https://learn.microsoft.com/en-us/power-query/append-queries

If this works, please accept it as a solution, it helps with visibility for others.