cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Henricus
New Member

Slicer for multiple datasources

Hi,

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.

 

Henri

 

 

 

4 REPLIES 4
Henricus
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.

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

 

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

AntonioM
Super User
Super User

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. 

rohit_singh
Super User
Super User

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,

Rohit


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

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors