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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Paulhaha
Helper II
Helper II

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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