Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

All Imported Tables to be turned into a Slicer



I have imported around 15 tables for this PBI Dashboard and added them all into a table visual. Is there a way to create a slicer that depending on which table it originated from that it will slice the table below. So for example Total Headcount and Overtime % are from the 'Employee Table' while Total Hours Worked and Total Injuries are from the 'Safety Table'. I would like to create a slicer type visual that puts each Column into Categories (Employee, Safety, etc) that when selected will filter the table below. 




Thank you!


Community Support
Community Support

Hi @Bryanna 

If you put all columns to the table visual, althrough the Total Headaccount is blank, but other columns are not blank, such as New Terms, you need to remove them, and only put the measure to the table visual, and can you provide the pbix file or the relationship between the tables?


Best Regards!

Yolo Zhu

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

Helper I
Helper I



I was able to create a Measure Slicer Table. Looking for other ideas however instead of using BLANK. Right now when you select the category in the slicer the table just blanks out the rows but i would like them to disappear instead. Below is the DAX used to create the slicer table.


Total_Injuries = if(contains('Measure Slicer','Measure Slicer'[Measure],"Safety Data"), [Total Injuries],BLANK())
Any ideas would be helpful!

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors