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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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