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

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is 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
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

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

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.