Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Aggregate sum not available for numeric slicer/slider

I have created a map that sums membership counts by state.

Fine.  Nice bubbles sized by aggregate summary count.

mfichman_0-1659991613041.png

 

Task: I have created a numeric 'between' slicer/slider to filter results down to only those states with a membership count between x and y.

mfichman_1-1659991645776.png

 

Problem: The slicer/slider is being created at the detail row level (0 or 1 count for each row) rather than the aggregate summary count per state level as shown in its related bubble map visual.

Question: Can I create a slider control based upon the aggregate summary state count (ex. 1,234 for Texas) rather than the detail row count (1)?

 

2 REPLIES 2
Anonymous
Not applicable

Thanks for the interest.

Simply put, the below table shows some example source data.  Each row has a 0 or 1 for Membership_Count.

The visual above's bubble amounts show the summation of Membership_Count (e.g. 2 for CT, 5 for CA, 7 for TX, 4 for FL, 5 for MI, 0 for LA and NC).  This is correct.

The slider shows only 0 to 1, representing Membership_Count on each detail record.  This is incorrect.

I'd like the slider to represent State_Province totals from the smallest (e.g. 0 for LA and NC) to largest (e.g. 7 for TX). 

Outside of pre-populating the source data with the totals on each row is there a way for PowerBI to do with the slider what it did for the bubbles - sum the total by State_Province.

Member_NumberMembership_CountState_Province
1234561CT
1234571CT
1234581CA
1234591CA
1234601CA
1234611CA
1234621CA
1234630NC
1234641TX
1234651TX
1234661TX
1234671TX
1234681TX
1234691TX
1234701TX
1234711FL
1234721FL
1234731FL
1234741FL
1234750LA
1234761MI
1234771MI
1234781MI
1234791MI
1234801MI
memepu
Resolver II
Resolver II

Hi @Anonymous ,

Could you please provide some sample data and your desired output? I cannot understand your meaning correctly. you can create simple data with excel, then show me the screenshots about the data and the desired output your want.

 

Best regards.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.