Slicer by Alias

[Anonymous]

I would like to use the Dimension Alias table as a slicer for data in my Primary Table. I do not need to aggregate. Trying to limit the amount of slicer selections to save screen real estate.

Dimension Alias Column

2D

3D

Primary Table

Dimension Column

2D On

2D Off

3D On

3D Off

[edhans]

You just have to relate the fields in the Model view of the desktop app.

If that isn't what you are asking, please be more specific in the details of what you have.

[Anonymous]

Hi @edhans. I forgot to mention that the data I posted is a column in the primary table. So the "2D off" and "2D On" are values in a Dimension column. Will update the post to reflect this.

[edhans · Accepted solution]

You have to create a primary table that has 2D and 3D as the key. You cannot use a measure for this as measures cannot be used in slicers. You could use a calculated column, but that isn't advised. Your best bet is to do this in Power Query. Use Text.Start([Field name],2) to create your column in the 2D on/off, 3D on/off table, and make the 2 record table "2D/3D" your DIM table (index/key) and your other table your FACT table.