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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
MP_123
Microsoft Employee
Microsoft Employee

filter on a measure

hi

i created new calculated measure.

i want the measure to appear on report only if it's not blank.

on the visual level filter, the option to change the settings of the filter from all to something else is disabled... (i think because there is no option on pbi to filter on a measure)

is someone have an idea how to solve it? 

thanks!

5 REPLIES 5
Sean
Community Champion
Community Champion

Visual Level Filters - can be both columns and measures!

 

What is your Measure formula?

 

MP_123
Microsoft Employee
Microsoft Employee

Capture132.PNG

MP_123
Microsoft Employee
Microsoft Employee

@Sean

the option to change the 'is less' is disabled...

and can enter data or apply

 

this is the formula:

Card Type Avg.3 = if(HASONEVALUE(Query1[Experience]), calculate(([Click Rate]),all(Query1[Experience])))

MP_123
Microsoft Employee
Microsoft Employee

hi,

 

is someone can help me?Smiley Happy

I have the same issue and it's driving me nuts. I have 2 reports. One where I have a simple chart based on a measure, and a visual filter (a calculated measure) that works perfectly. I have a second report nearly identical but with a different simple chart (of the same type). The visual filter is the same exact calculated measure. On the second report, the apply filter is disabled, and I can't get it to apply? What is up with this Microsoft???

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.