Forum Discussion
SelectedValues will not filter on multiple values
ok, that eliminated the error but no charts on that page get filtered. Here is what I am trying to do. I have an Account table with the AccountType as one of the columns. I have added a ClicletSlicer that has two options. When I select "Main Account Types(with Prisoners), I want it to filter the Account Table. It would be the same as adding the AccountType as a Page Level or Report Level filter and making the user select which types of AccountType he wants to filter on. But I want it to be done using the ClicletSlicer to do the filtering of all charts on that page that use the Accounts table. I added the above code as a Measure on the Accounts table.
Hi rwyoung01
You may try to add the measure to visual level filters for all the charts which need to be filtered like below:
https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/
Regards,
Cherie
My user would get confused. I want to use a Chiclet slicer
v-cherch-msft wrote:Hi rwyoung01
You may try to add the measure to visual level filters for all the charts which need to be filtered like below:
https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/
Regards,
Cherie
v-cherch-msft wrote:Hi rwyoung01
You may try to add the measure to visual level filters for all the charts which need to be filtered like below:
https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/
Regards,
Cherie
Hi rwyoung01
The visual level filter can be used to filter the visual.Please refer to the attached sample file.
Regards,
Cherie
This is closer but I have to apply it to all the objects on the page and there are several pages. Is there no way to make it work like the visual filter for Account Type that when you select a type it affects all objects that reference that table.