Forum Discussion
scatter chart drill down
I have 5 columns in PowerBI: impact score(numerical column), likelihood score(numerical column),product (text column), batch (text column) & sector name (text column). The scores are assigned at a product level. Product comes under batch and Batch comes under sector name. I want to create a scatter chart in powerBI where I want to display likelihood vs impact score. Initially the numerical columns should be averaged on a batch level, then they should be averaged on a sector level. So that initially we see in the scatter chart only scores for sectors, however we should be able to drill down a particular sector down to batch level
2 Replies
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523xample i have taken to show what the scatter plot is working in power bi
in my data I shown data for city and state .. to show the relashionship between flight delay time and distance .. so its working as drill downso in your example you have to take batch level,a sector level filed induvduially in the scatter plot to show the compare bbetweeen likelihood vs impact score.
