topic Re: Pre Filter Visuals to limit data shown in Custom Visuals Development Discussion

Pre Filter Visuals to limit data shown

SnymanGrobler — Thu, 07 Mar 2024 10:07:28 GMT

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.

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

Re: Pre Filter Visuals to limit data shown

lbendlin — Thu, 07 Mar 2024 18:32:25 GMT

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 🙂

Re: Pre Filter Visuals to limit data shown

Anonymous — Mon, 11 Mar 2024 09:49:06 GMT

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