Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
111 | |
59 | |
57 |