Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello team,
I have looked through multiple questions and responses but could not quite replicate the solutions given. The closest answer was this:
How to apply a slicer from one table to another ta... - Microsoft Power BI Community
However, my use case is slightly different. I will try my best to be articulate.
There are two data sets:
Data Set 1 - A primary list of local authorities with a single index
Data Set 2 - Nearest neighbour dataset with a repeated index by local authority
I unfortuently cannot upload a test document for a reproduciable example. But here are extracts of what each dataset looks like:
Data Set 1
Data Set 1
Data Set 2
Data Set 2
Output
So I now have a list of neighbours, but I cannot seem to action that into any kind of filtering. Is there any way I can take those items above and make a binary flag in other data set for those names?
Hi @jbaisley , although I do not any clear connection between both datasets what you can try to do is to add a TREATAS() to the measure on the visual you shared. Something in the lines of:
measure_name =
CALCULATE (
Measure[Your calculation],
TREATAS ( VALUES ( 'dataset1'[Authority Group] ), 'dataset2'[INDEX LAD22NM] )
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Thanks @goncalogeraldes. I don't have an existing measure as the data set is wide format I am calling out rows that match the authority name. It would be very time consuming to make a measure for each graphic and then a second for neighbour selection. Ideally it would be a binary flag in existing data meaning I could simply pull the column though as a group and then aggregate ethe values I need by that group then and there. If it helps to restate my question. How can I have a dynamic measure/ column appear in Dataset1 when a slicer selects an authority in DataSet 1, such that a group of authorities is selected from Dataset2 so that they can be used a legend in graphics. In theory the measure should just be a list of place names, should it not?
I may have solved it. Then use this measure as the legend? It gives me the right output. Its where it can be used as intended.
Measure = var a = VALUES(Data Set 1[Authority])
return
IF(MAX(Data Set 2[Authority]) in a, 1,0)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
13 | |
10 | |
8 | |
7 |
User | Count |
---|---|
17 | |
10 | |
7 | |
6 | |
6 |