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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.