Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to 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
Hi @SH_Ishikawa
Assume you table is caleed "Sheet3",
Then create a new table by "Home->New Table", entering formula below
Table = 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)
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,
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
Thank you for all your helpful advice.
Thanks to all, I was able to solve all the problems.