Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Community,
I have ~2000 location points on a map visualization (quite a mess), which are relating to transport routes. In the same time I also have a table of transport route data.
Is it possible, that only those location points are visible, which are seleted on the table (e.g. click on transport route ID)? This would mean that the map would appear as empty at the beginning.
Thank you for your help in advance!
Peter
Solved! Go to Solution.
Hi @Anonymous ,
Make sure there's no active relationship between these two tables.
Then create a measure as below.
Measure = IF(ISFILTERED('Table 2'[location]),IF(SELECTEDVALUE('Table'[location]) in VALUES('Table 2'[location]),1,0),0)
And add this measure to the visual level filter.
Result would be shown as below.
Best Regards,
Jay
Hi @Anonymous ,
Make sure there's no active relationship between these two tables.
Then create a measure as below.
Measure = IF(ISFILTERED('Table 2'[location]),IF(SELECTEDVALUE('Table'[location]) in VALUES('Table 2'[location]),1,0),0)
And add this measure to the visual level filter.
Result would be shown as below.
Best Regards,
Jay
@Anonymous , you can try with is filtered or has one value
Check video for reference
A new measure like this https://www.youtube.com/watch?v=hXg3kRFSGjA
if(isfiltered(Table[route]) , [Measure], blank())
refer: https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Hi @amitchandak ,
we are close with the isfiltered function! 🙂
In your suggested formula if(isfiltered(Table[route]) , [Measure], blank() --> what kind of measure can provide multiple rows of the location ID column as result?
In my use case it is important, because for a selected transport route at least 2 (pick-up and delviery) locations are relating.
Thank you very much in advance!
Peter
@Anonymous How many items do you want them to be able to select in the table? This should work by default except for the part about the map being empty at the beginning. You may just need to Edit Interactions and set the map to Filter when a table row/item is selected.
Getting it empty at the beginning can be done with a measure, but then you need to define how many points can be selected and still not have an empty map - all but one? just one?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |