cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
soldous
Helper III
Helper III

Dynamic "Group by" with custom sorting

Hi,

 

I have a table with activities of users. Each record has user name and date of the activity.

 

I need to create clusters of activity counts like this:

ranges.PNG 

The grouping needs to be dynamic based on the Date filter selection.

In the end I need two visualisation to be able to filter each other:

tempsnip.png

The visualisation Count of Users by # of activities should represent number of users in each cluster in the Date filter context. By clicking on the bar the table List of Users should be filtered on the users in the cluster. By clicking on the user in the table the visualisation should show to which cluster the user belongs.

I can't figure out how to connect the visualisations because there is no key how to connect custom Ranges table and the original table with activities.

 

Could someone help?
Thanks in advance! 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

hI @soldous 
Place [Count of Accounts] measure in the filter pane of the table viual and select "is not blank" then apply the filter

View solution in original post

4 REPLIES 4
tamerj1
Super User
Super User

hI @soldous 
Place [Count of Accounts] measure in the filter pane of the table viual and select "is not blank" then apply the filter

Thank you @tamerj1 

After all, this solution was correct. I had to change the inner measure for Count Of Activities also to count users with no activity as 0. 

But I need one more visual to be filtered by the ranges. The visual is for Number of Unique Daily Activities calculate like this:

UniqueUsers/Day = VAR tempTbl = ADDCOLUMNS ( SUMMARIZE ( daily_acitivity, daily_activity[Activity Date], "Users", DISTINCTCOUNT ( daily_activity[Username] ) ), "Days",1 ) RETURN SUMX ( tempTbl, [Users] )

 

By applying the same logic to filter this visualization from the clusters doesn't work. Do you have any idea?

Hi @tamerj1 

 

Thank you. Is there any other way? By applying the filter I'm going to lose some needed information. Basically, there are also users without any activity in the table and I need to keep them there.

@soldous 

You may try

FilterMeasure =
INT ( ISBLANK ( [# of activities] ) || NOT ISBLANK ( [Count of Accounts] ) )

Place it the filter pane of the table visual and select "is" and type "1" then apply the filter

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors