Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ICD
Helper I
Helper I

Is 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 2
Anonymous
Not applicable

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

vyangliumsft_0-1720058327379.png

 

 

 

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.

Hi, @Anonymous 

Thank you for your answer! My question is:  Is it possible to apply filters at table visual level (basic/advanced from filter pane) to a measure.

Is your answer - No?

Best regards,

@ICD 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.