cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SH_Ishikawa
Regular Visitor

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

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,dashboard.PNGTable.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

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

10.png

 

Please refer to my pbix->Page2

 

Best Reagrds

Maggie

View solution in original post

6 REPLIES 6
Community Support
Community Support

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

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.
4.png
 
 
Best Regards
Maggie
 
 
SH_Ishikawa
Regular Visitor

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

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 Resolver I
Resolver I

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

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
Regular Visitor

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

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,

 

dashboard and pie chart settings.png

Community Support
Community Support

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

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

10.png

 

Please refer to my pbix->Page2

 

Best Reagrds

Maggie

View solution in original post

SH_Ishikawa
Regular Visitor

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

Thank you for all your helpful advice.

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors