Forum Discussion

jaywh1999's avatar
jaywh1999
New Member
1 year ago

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 made in another slicer I want the frequency to update to reflect change.

 

Tier  
Tier A4,123
Tier B956
Tier C21,589
Tier D215
Tier E9
Need Help

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.