cancel
Showing results 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

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.

Thank you for your cooperation and regards,

1 ACCEPTED SOLUTION
Community Support

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

6 REPLIES 6
Community Support

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

Regular Visitor

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.

Regards,

Resolver I

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

Regular Visitor

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,

Community Support

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

Regular Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors