Forum Discussion
slicer frequency
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 m...
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.