Forum Discussion

akasthan's avatar
akasthan
Microsoft Employee
4 years ago
Solved

Dynamic filtering in PowerBI report

Hi PowerBI community members,

 

I am looking for somekind of dynamic filtering functionality in PowerBI. Basically someway of maintain a list in PowerBI report, the list will contain data (lets say company name) which needs to be excluded/hidden in the report.
I can think of couple of ways of doing this:

1. Filter the data at the time of query. In this case for any updation in the list, pbix file need to be downloaded and edited.

2. Put the list of company names in some alternate source like sharepoint/data lake etc. and use it as a data source. If the list needs we can update it at the source and refresh the report. The report now will exclude the data with the company names from the list.

 

But is there a way to maintain the list in the report itself? Any visual which support such kind of thing?

If we want to update then instead of going at some other source, we can just update it in report itself.

I will explain it from example:

Lets say we have this data as a table in report.

CompanyUsersDepartment
Apple2000A
Mango100B
Test33C
Banana22D
Demo500E


It has 2 test companies, "Test" and "Demo". So we will need to create a list of excluding company so that the final report will only show

CompanyUsersDepartment
Apple2000A
Mango100B
Banana22D



1 Reply