Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Can Parameter Filter All Dataset?

Hello Power BI Community,

 

I am currently working on a Power BI report focusing on item usage statistics within the PowerBIUserActivity dataset. My goal is to allow users to filter the entire report dynamically based on a specified activity range. I have a slicer for the 'Activity Number'[Activity Number] column, and I want this slicer to influence all visuals related to the ItemName column.

 

Here are the key components of my solution:

 

  • Activity Number Table: I have a table named 'Activity Number' with the 'Activity Number'[Activity Number] column, generated:
    1. Using the DAX formula: Activity Number = GENERATESERIES(0, 10000, 1)

 

  • TotalActivities Measure: I'm using the following measure to count the activities, considering the selected activity range from the slicer: TotalActivities = COUNT(PowerBIUserActivity[ActivityId])

 

  • Slicer Implementation: I have created the following measure to filter the Items in terms of their activity counts. The measure:

 

    • ActivityFilter = IF([TotalActivities]>= MIN('Activity Number'[Activity Number]) && [TotalActivities] <= MAX('Activity Number'[Activity Number]),1,0)  
  • Filtering: The idea is that changing the slicer values will dynamically filter all visuals and tables related to ItemName based on the selected activity range. However, this is only work where I can put my activity filter on additional filter on the tables. I cant add this measure to all page because not all my tables and graphs have item name directly or activity related information. But I want to filter my dataset with this Activity Range Slicer (Parameter). Is this possible to do it or is there any other way of doing this?

 

Request for Feedback: I would like to know if there's a more efficient or alternative way to achieve this goal. Any feedback, suggestions, or insights from the community would be highly appreciated.

1 Reply