Scatter chart showing the wrong output.

[Anonymous]

Hi,
Trying to create scatter plot chart X and Y axis dynamically.

It’s a dummy data.
Here you can see level filter where we have 2 type ‘Filter’ and ‘Total’.
If user don’t select any filter ‘Device Type’. So, data on scatter plot chart should show the total level data.
if user select any filter value from the ‘Device Type’ it will show the data on filter level for selected device type.

In my scenario have created one measure to show 1 and 0 based on the condition and put it into the filter pane to filter out only value 1 data.

here is my measure”
IsDeiveSelected =

var deviceselected = SELECTEDVALUE(FilterTable[DeviceType])

RETURN IF(deviceselected = BLANK(), IF(TRIM(MAX(Sheet1[Level])) = "Total", 1, 0), IF(TRIM(MAX(Sheet1[Level])) = "Filter", 1, 0))

Its working on table fine as below screenshot :-

But as you can see on scatter chart it should show 3 bubble instead of 2.
1,1 1,2 and 2,1 but its showing on the graph 1,1 and 1,2.

Need help to solve this problem.
I have been trying lot of thing to achieve but didn't get any answer.

[Anonymous]

Hi  @Anonymous ,

You can consider creating Index and use Index for DISTINCTCOUNT

In Power query. Add Column – Index Column – From 1.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.