Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I am using PowerBI desktop to build a report. I have a map and a line chart that interact, they work great. When I select a data point plotted on my map, the line chart displays the data correctly. This looks great when I have selected a point on the map, but before that when the line chart is displaying data for all points it looks like a big blob of data ugliness and doesn't make sense.
Can I configure my line chart or use another chart that displays no data, until a point on my map is selected?
Thanks,
Mike
Create a measure with HASONEFILTER
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Thanks ImkeF, this is amazing, however it doesn't work on multiple selection. (Using CTRL on windows)
That's why he's called "HASONEFILTER". Thought this was what's been requested 🙂
If you want to make it show up on multiple filter selection, try ISFILTERED.
Also check out this article
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 66 | |
| 41 | |
| 39 | |
| 39 | |
| 38 |