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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
SnymanGrobler
Frequent Visitor

Pre Filter Visuals to limit data shown

Hi all,

 

Is their a way to limit the amount of data when a visuals loads by setting a Pre Filter, but when slicers are used it overides the pre - filter.

OR

As shown below i have a Line Graph and a Custom Search Slicer. if no value is searched the graph is a complete mess. How would I go about hiding the visual if no value is searched.

SnymanGrobler_0-1709797544808.png

I am using this Search Slicer: Business Apps – Microsoft AppSource

2 REPLIES 2
Anonymous
Not applicable

Hi,

 

In the dataviews, when a filter is applied (from a slicer or from a general filter in filter pane), you can get the "isDataFilterApplied" attribute to true: 

 

public update(options: VisualUpdateOptions) { console.log(options.dataViews) }  

 

Paulhaha_1-1710150539065.png

 

 

You can probably use this to only create you chart when this attribute is set to true

 

Hope it answers your question

 

Have a good day

 

 

lbendlin
Super User
Super User

create a measure that tests for ISFILTERED  and then use that as a visual filter.

 

There is a small caveat, I'll let you find that yourself 🙂

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

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.

Top Solution Authors
Top Kudoed Authors