Showing results for 
Search instead for 
Did you mean: 
New Member

Slicer for multiple datasources


I have a question about slicers.
I have multiple csv files with the same columns, but different data.

These have a column with names, and a column with only true/false and a column with a numerica value.

Also I created a graph, with data from those files. No I want to have a slicer with possibility to select the true/false value and adjust the graph based on that, for all those different sheets.

Is this possible, and could anyone guide me a bit in the solution if so?
Thanks in advance.






New Member

Thanks for your replys @AntonioM & @rohit_singh . 

For some reason it doesnt work. But thats more because I think I explained something wrong. Also because I just figured it out that I did that.

Long story short, I don't think with my files I can get the result I want and need to alter my files. But I really don't know for sure how to do it.. So I probably will quit.

Solution Specialist
Solution Specialist

Are you sure? What you've asked about definitely sounds doable. 


What is it about your files that's the problem?

Solution Specialist
Solution Specialist

You can create a new table, just with two rows that say True and False. Link this to all of your datasource tables and then use it in the slicer. 



Another way would be to combine your csv files together. If they all have the same columns that could be worth doing anyway. You'd have another column saying which file any row originally came from that you could use to separate them. 

Solution Sage
Solution Sage

Hi @Henricus ,

You can create separate dimension tables to use as a common filter for all your tables. 
For instance, you can create a table with a single column, that has two values, True or False
Then create a relationship between this table, and each of your data tables on the True/False column. On the report view, use the true/false column from the dimension table as a slicer.
Once you select a value from the slicer, your data tables will be filtered accordingly.

Kind regards,


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊

Helpful resources

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors