Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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
v-juanli-msft
Community Support
Community Support

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
 
 

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,

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

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

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

Thank you for all your helpful advice.

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Kudoed Authors