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:
- 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.
