Creating a Drill Through Power BI Scatter chart

[Anonymous]

I have address data in my power BI desktop application that includes address, City, State, Zip and School Name

I'm trying to create a scatter plot using that data so a user can click on the scatter plot for that school and it will pull up the data for that school. 

So far all of the Scatter plot examples I've tried and downloaded don't seem to work.

Any suggestions would be appreciated.

TIA

[andrewpirie · Accepted solution]

I don't believe it's possible to have a single-click drill-through from a visual. What I've done in the past to work around this, is to have a button with a drill-through action, which automatically knows if there's a selected value for the drill-through column(s) and enables if there is a selection. 

Here's how that looks:

Not quite as intuitive as just clicking a point to drill through, but I believe this may be an option.

If it drills through okay, but doesn't filter to show the school on the drill-through page, you may need to do some DAX or data modelling changes to make the filter on address filter school.

[Anuja_Chaudhari]

Create a Button: Insert a button into your Power BI report. Configure the Button: Set up the button so that it performs a drill-through action when clicked. Enable Dynamic Clicking: Make the button "smart" by configuring it to be clickable only when there's a selected data point in your scatter chart. Drill-Through Column(s): Define the column or columns in your data that you want to drill through. Automatic Enablement: Configure the button to automatically enable itself only when you've clicked on a point in the scatter chart (selected a value for drill-through). This way, when you click a point on the scatter chart, the button becomes clickable, and clicking the button then takes you to a more detailed view based on the selected data point. It's a workaround to achieve a single-click drill-through experience in Power BI.

in the snap shot  when you click the button below it take you the next page 

[jjrand]

Hello,

It's hard to get a picture of what your goal is, since there's no sample data or images, but you might want to look into drillthourgh functionality