Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am trying to do a scatter plot visual that includes total sales by customer. The way my dataset is currently setup; there are multiple lines for the same customer (all lines add up to the true total sales). When I add sales to the scatter plot along with a slicer (that includes sales) to be able to view customers sales by a certain range, Power BI is not reading the true "Total Sales". See example below on what is occuring.
Customer A total sales = $9
Customer B total Sales = $3
If I slice it to say anything less than $8 customer B should only show, but power BI is reading each individual line and showing customer A at $7. Is there a way to create a formula or expression to where power BI would read Customer A at a total of $9 and B at $3 so that my slicer would work correctly?
@JAS2022 , Create a numeric ?what if param and follwing measure
Total Sales = sum(Table[Sales])
GT Selected = sumx(values(Table[Filter]), if([Total Sales] >= [Parameter Measure] , [Total Sales], blank() ) )
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 32 | |
| 19 | |
| 12 | |
| 10 |