Forum Discussion
Deleted
Deleted
Hi agarwala ,
You can add report-level filters to an entire report. From the Fields pane, select the field that you want to add as a new report-level filter and drag it to the Report Level Filters area. The visual objects on the active page and on all pages in the report change to reflect the new filter. If you save a report using filters, the report reader can interact with the filters in the Reading view to select or clear values.
Page 1:
Page 2:
Alternatively, you can synchronise the slicer and use it on any or all pages in the report.
More details can be found in the documentation: Slicers in Power BI - Power BI | Microsoft Learn
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi agarwala ,
You can write the filter conditions into the dax formula, at this time no matter which page to use, it is the same filter conditions. You can refer to the following example:
Measure = IF(MAX('financials1'[Country]) = "Canada" || MAX('financials1'[Country]) = "France", 1)page 1:
page 2:
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi agarwala ,
You can add report-level filters to an entire report. From the Fields pane, select the field that you want to add as a new report-level filter and drag it to the Report Level Filters area. The visual objects on the active page and on all pages in the report change to reflect the new filter. If you save a report using filters, the report reader can interact with the filters in the Reading view to select or clear values.
Page 1:
Page 2:
Alternatively, you can synchronise the slicer and use it on any or all pages in the report.
More details can be found in the documentation: Slicers in Power BI - Power BI | Microsoft Learn
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for replying back Clara but I do not want report levele filters I only want them on the specific pages.
Tried using slicers but it degarded the performance a lot.
I am trying to explore "Use DAX Expressions to Sync Filters" .
Does anyone have any idea about how to do that?
CheersArti
Hi,
I am trying to synchronise filters on different visuals between different pages so report level filters wont work and I guess slicers are making my report too slow .
Trying to use the option "DAX Expressions to Sync Filters" if someone can guide me in this direction pls that would be really helpful.
Thanks
Arti
Hi agarwala ,
Visual object level filters only work on the currently set visual object, it's not possible to use dax on other pages to get the current filter selection, so I don't think it's possible to implement synchronising filters using DAX expressions.
For now it looks like synchronising the slicer might be your best option. In the meantime, you can try to optimise power bi in other ways, e.g. data source, data model, visualisations, etc.
More details can be found in the document: Optimization guide for Power BI - Power BI | Microsoft Learn.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Clara,
Thanks for replying.
I saw the option of using DAX expression to synchronise filters in this article.
But dint understand how to do it as i have never done it before.
https://www.process.st/how-to/sync-filters-in-power-bi/
So wanted to know if its possible or not.
Cheers
Arti
Hi agarwala ,
You can write the filter conditions into the dax formula, at this time no matter which page to use, it is the same filter conditions. You can refer to the following example:
Measure = IF(MAX('financials1'[Country]) = "Canada" || MAX('financials1'[Country]) = "France", 1)page 1:
page 2:
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
