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

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

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
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

Top Solution Authors