Forum Discussion
Resolver IPopulate table visual through a field not connected in the data model
Hi,Quenril
If you want to keep the original slicer Settings, but want it to affect another column, in addition to my new table as a slicer, the only way I can provide now is to break the relationship between the two tables or directly change the inactive relationship to the active relationship, because the functionality of the slicer always can only filter the column that created the slicer or the column that has a relationship with his table, as I did before The table affected by the slicer is replaced with another table, and after obtaining the slicer value with the degree value, another column of the original table is filtered.
1.Here are my updated measure based on the data you provided, disconnecting all relationships:
REFERED = VAR CC=SELECTEDVALUE('consultant lookup'[Consultant Name]) RETURN IF(ISFILTERED('consultant lookup'[Consultant Name]), CALCULATE(MAX('live job'[Referred by]),FILTER('live job','live job'[Referred by]=CC)),MAX('live job'[Referred by]))2.Of course, you can achieve the same result if you choose to change the inactive relationship to the active one as shown below:
3.Here's my final result, which I hope meets your requirements.
4.Here is the relevant documentation:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Please find the attached pbix relevant to the case.Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Resolver IHello Leroy,
Thank you so much for this. The outcome is exactly what I am after, however the only difficulty I have is that the combination of the Consultant who owns the job and the Consultant who referred the job changes every time, so I can't create a table with those items listed as they are dynamic. Can you think of any other way to achieve the same outcome?
I have uploaded here some sample data. So for the table called 'Live Roles', when I select the Consultant Name in the slicer, I need it to filter on column G 'Referred by' instead of column B 'Consultant Name'....
Live Roles table - Live Jobs SAMPLE DATA.xlsx
Consultant lookup table - Consultant lookup SAMPLE DATA.xlsx
Thank you
Quenril
Hi,Quenril
If you want to keep the original slicer Settings, but want it to affect another column, in addition to my new table as a slicer, the only way I can provide now is to break the relationship between the two tables or directly change the inactive relationship to the active relationship, because the functionality of the slicer always can only filter the column that created the slicer or the column that has a relationship with his table, as I did before The table affected by the slicer is replaced with another table, and after obtaining the slicer value with the degree value, another column of the original table is filtered.
1.Here are my updated measure based on the data you provided, disconnecting all relationships:
REFERED =
VAR CC=SELECTEDVALUE('consultant lookup'[Consultant Name])
RETURN
IF(ISFILTERED('consultant lookup'[Consultant Name]),
CALCULATE(MAX('live job'[Referred by]),FILTER('live job','live job'[Referred by]=CC)),MAX('live job'[Referred by]))
2.Of course, you can achieve the same result if you choose to change the inactive relationship to the active one as shown below:
3.Here's my final result, which I hope meets your requirements.
4.Here is the relevant documentation:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.