slicer frequency

[jaywh1999]

Is there a way in Power BI to create a slicer with a frequency that updates when a selection is made in another slicer.    The example below has the number of rows for each tier.  If a selection is made in another slicer I want the frequency to update to reflect change.

Tier
Tier A	4,123
Tier B	956
Tier C	21,589
Tier D	215
Tier E	9

[Anonymous]

Hi @jaywh1999 ,

According to your statement, I think your requirement is to record the using frequency for each tier in a slicer.

As far as I know, Power BI Desktop is a visualization and analysis tool, not a database.
Although Power BI Desktop can connect to a variety of different data sources, Power BI Desktop is read-only for these data, and we can't modify the content of the data sources in Power BI Desktop.

Therefore, Power BI Desktop does not support your need to use it as a database to record the number of times a slicer is used.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Hi @jaywh1999 -you can create a measure that calculates the count of rows for each tier dynamically based on slicer selections.

eg: Frequency =
COUNTROWS(
FILTER(
Financials,
Financials[Tier] = SELECTEDVALUE(Financials[Tier])
)
)

the above measure will update dynamically based on the filters applied from other slicers.

take a  table or Matrix visual to display the Tier column and the Frequency measure.Make sure the slicer for the other attribute (e.g., Date, Category, etc.) is affecting this table through Edit Interactions (ensure filtering is applied to the frequency table).

Now , add a slicer for the Tier column.This slicer will filter the frequency table to show the counts specific to the selected tier(s).

this works , please check.