Forum Discussion

SnymanGrobler's avatar
SnymanGrobler
Frequent Visitor
2 years ago

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.

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

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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) }

     

     

     

    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