Filtering by two group of values

[Anonymous]

Hello!

I have an "A" table that shows all the accounts that I have. I also have another "B" table that just shows a small group of accounts (which are also included in the A table).

I'm trying to do a slicer so that I can choose whether to show all accounts (A table), or just the small groups (B table) and having my visualizations updated accordingly.

I thought about creating a new table but I'm not sure what to do next.

Any help would be great! Thanks in advance.  

[edhans · Accepted solution]

You should only have one Accounts table. It sounds like you need an attribute column in that table that is "Limited" with a value of "Subset" or "All" (use your own words) then you can filter the report on the "Subset" account or "All" accounts.

To help further, we need more info.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

[Anonymous]

Ohhh yes! I think I got it. Thank you very much!