Forum Discussion
Filtering data sources using a single slicer for dashboard visuals
I have two different data sets that each have similar information but for different respective "owner groups". I want to add a single slicer on my dashboard that, if for example I select "Dataset 1", it will show information on all my visuals in regards to the owner groups in Dataset 1. Then, if I check "Dataset 2", the visuals will filter and change for the owner groups in Dataset 2. I read on the forums that it is recommended to create a different data set, which I did and it has one column called Owner groups. I then linked the "Ownergroup" column from Dataset 1 -> the new table and "Ownergroup" column from Dataset 2 -> the new table. I added the slicer but nothing happens. Dataset 1 has a column called "Ownergroup" with 5 different groups. Dataset 2 has "Ownergroup" with 6 different groups. I'd appreciate any help! Thank you!
Nevermind, I figured out how to do it. After creating the new appended table, I created a new column in it that had an IF statement that labeled each subgroup as either Group 1 or Group 2. Then I created a slicer based off that column. Thank you for your help.
12 Replies
Hey,
please excuse, but first I want to introduce some wording, I'm not sure, but I assume by referring to a dataset you actually mean a table. In the world of Power BI a dataset is considered a collection of tables.
Now I'm using the the word table instead of dataset.
I'm not sure what "similarity" actual means, but it's not possible to "switch" the content of a visual to a differnt table, no matter if we are talking about a table visual or a bar chart.
If similarity means, both tables have the same column structure, but contain data for different regions, the solution might be "simple".
Just follow these steps using Power Query:
- Create a new column in each table that explicity allows to differentiate both tables, https://docs.microsoft.com/en-us/power-bi/desktop-add-custom-column
- Append one of the tables to the other one, https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Now you can create a slicer, based on the column "Ownergroup".
Hopefully this provides some ideas how to solve your problem.
Regards,
Tom
I apologize about the confusion. I come from the world of R, so I am used to using "dataset" as a data table. As for the new column in each of my two data tables, what should I name it and what should be the contents underneath them? Then I just append the first table to the second one? I am a little confused. TomMartens
Hey,
not sure how to name the column, the approach I mentioned only makes sense if both tables contain similar content, and only differentiate in one aspect. For example table 1 contains sales date for region 1 and table 2 contains sales data for region 2. Then you can name the new column "Region" and assign the appropriate values, tablewise.
And then just append one table to the other.
Hopefully this clarifies my 1st post a little bit.
regards,
Tom
