Forum Discussion
ICD
Helper I
Helper IIs it possible to apply filters at table visual level (basic/advanced from filter pane) to a measure
Hi!
I need help: is it possible to apply filters at table visual level (basic/advanced from filter pane) to a measure in card visual?
I have:
one slicer by project
table visual with property units filtered by this slicer: (data in table visual: property unit code, building code, area ,...etc.)
one card visual - showing the measure for count of property units
msPUCount_ALL =
CALCULATE(
COUNT(PropertyUnit[PropertyUnitId])
)
When I filter by project (slicer) the measure is correct calculated.
When I apply basic filter by building on table visual level, not on page level => this filter is not applied to the measure.
I tried to add ALLSELECTED , KEEPFILTERS - without success
msPUCount_FilteredALLSELECTED =
CALCULATE(
[msPUCount_ALL],
ALLSELECTED(PropertyUnit)
)
When I hide the filter by building at table level and add filter by building at page level, the measure is correct calculated, but the possible buildings in filter pane are not filtered by project slicer
2 Replies
Hi ICD ,
As far as I know, the slicer works on the visual associated with the whole page, and the visual level only works on the visual itself, not on the other visuals.
You can set up three different levels of filters for the report in the Filters pane:
- The visual level. -- You can also add visual level filters to filter this visual.
- The page level. -- You can also add a page-level filter to filter an entire page.
- The report level. -- You can also add a report-level filter to filter an entire report.
Add a filter to a report in Power BI - Power BI | Microsoft Learn
If you only want to filter one or two visuals on the entire page without affecting the other visuals, you might consider using a slicer and then using Edit interactions to cancel the slicer's effect on the other visuals
Change how visuals interact in a report - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
