cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper V

## Scatter Chart where user selects X, Y axis indicators

Given a table of indicators and values, shown below, I simply want to plot these on a scatter chart where the user can select the X axis and Y axis indicators. I think I'm going to have to set up measures, one for each axis, to accomplish this? What's the best approach? Thanks.

(ETA, the data doesn't align with the chart above. Just showing off the desired behavior.)

1 ACCEPTED SOLUTION
Super User

@bvy , Based on what I got. You need two independent slicer tables and then you can create a measure like

m1 = calculate(sum(Table[Value]), filter(Table, Table[Indicator] = selectedvalue(slicer1[Indicator])) )

m2 = calculate(sum(Table[Value]), filter(Table, Table[Indicator] = selectedvalue(slicer2[Indicator])) )

You use these two measures . For details, you can use any other column or add an index column and use that in details

3 REPLIES 3
Super User

@bvy , Based on what I got. You need two independent slicer tables and then you can create a measure like

m1 = calculate(sum(Table[Value]), filter(Table, Table[Indicator] = selectedvalue(slicer1[Indicator])) )

m2 = calculate(sum(Table[Value]), filter(Table, Table[Indicator] = selectedvalue(slicer2[Indicator])) )

You use these two measures . For details, you can use any other column or add an index column and use that in details

Helper V

@amitchandak Thank you. That's good but maybe I'm doing something wrong. Implemeted as shown, I only get one point on the scatter chart (presumably the SUM in your DAX?). I need to see all the points individually.

Helper V

Anyone else?

ETA: Reading through your post again, @amitchandak , I see I needed something in the "Values" column to designate a grouping. There's a timestamp assocaited with each set of readings (not shown in my data sample, sorry about that) and that was the ticket. Thanks.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors