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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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 I
Helper I

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors