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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.