How to represent the different data after you click in the scatter chart

[SH_Ishikawa]

I'm correlating data using four data points, product No., product ID, area code, and date of incident.
I have 2 data points represented in the scatter chart.
In the pie chart I have gathered cases in which the product No., Product ID and date were the same but the area code is different.
I want to be able to represent the different area code data in a pie chart for summarization.
Any advice?

Thank you for your cooperation and regards,

[v-juanli-msft]

Hi @SH_Ishikawa

Assume you table is caleed "Sheet3",

Then create a new table by "Home->New Table", entering formula below

Table = Sheet3

Then create measures in Sheet3

Measure = SELECTEDVALUE('Table'[product no])

Measure 2 = SELECTEDVALUE('Table'[id])

Measure 3 = SELECTEDVALUE('Table'[date])

Measure 4 = IF(MAX([product no])=[Measure]&&MAX([id])=[Measure 2]&&MAX([date])=[Measure 3]&&MAX([area code])<>SELECTEDVALUE('Table'[area code]),1,0)

Then add columns from Sheet3 to visuals and add [Measure4] in the Visual level filter of this visual, and select "show values when items is 1"

select an item from "Table", you will see the associated lines on Sheet3.

Best Regards

Maggie

[SH_Ishikawa]

Thank you for your answer. Now I can create Sheet 3 myself.

I want to be able to summarize the different area code data as well.

Looking at Measure 4, represented by a 1 in lines 2, 3 and 4,

I want to represent that in a pie chart, but it will not dsiplay properly.

Please help me with a solution.

Regards,

[Nickgastaldi]

Hi @SH_Ishikawa

can you explain what is not being displayed properly? looking at Maggie exemple, all you need to do is set a visual level filter on your pie chart to not display 0 in measure 4, 

unless i understood what you want wrong

[SH_Ishikawa]

I added a count of area code to the Table you created.

(Because of the Japanese version, please understand that some words are different from the English version.)

I want to display this count in a pie chart when I click a line in the Table.

I set the pie chart to:

  ・Legend: area code

  ・Value: COUNT of area code

  ・Visual level filter: Measure 4 represented by a 1

However, the pie chart will not display.

It is not displayed even if you select a line of the Table you created.

I'm not sure what went wrong with my pie chart settings. Any advices?

Please attach an image if possible and explain.

Thanks again,

[v-juanli-msft · Accepted solution]

Hi @SH_Ishikawa

Create a new measure

Measure 9_count = CALCULATE(COUNT(Sheet3[area code]),FILTER(Sheet3,[Measure 4]=1))

add Sheet3[area code] in the "Legend" and Sheet3[Measure 9_count] in the "Value" field of the Pie Chart.

don't add [measure4] in the Visual Level filter.

set the interaction among "table1" and  "pie chart" as below

Please refer to my pbix->Page2

Best Reagrds

Maggie

[SH_Ishikawa]

Thank you for all your helpful advice.

Thanks to all, I was able to solve all the problems.