Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a measure like this:
Solved! Go to Solution.
It sounds like the issue you are experiencing may be related to the way the measure is being evaluated in the context of the table and the slicer. When you add the URL measure to the table, it may be causing the table to evaluate the measure in a different context than the slicer, which can result in unexpected behavior.
One possible solution is to modify the measure to use the FILTER function instead of the SELECTEDVALUE function. This will ensure that the measure is evaluated in the same context as the slicer. For example, you could try something like this:
Item Link = VAR SelectedID = SELECTEDVALUE('List Directory'[ID]) VAR SelectedSysID = SELECTEDVALUE('List Directory'[SysID]) RETURN IF(LEFT(SelectedID,3)="ABC", CONCATENATE("https://www.somesite.com/nav_to.do?uri=tablename.do?sys_id=", SelectedSysID), CONCATENATE("https://www.somesite.com/nav_to.do?uri=anothertable.do?sys_id=", SelectedSysID) )
Alternatively, you could try adding the URL measure to the visual as a tooltip instead of as a column in the table. This will allow you to see the URL when you hover over the data points in the table, without affecting the filtering behavior of the slicer.
I hope this helps! Let me know if you have any further questions.
It sounds like the issue you are experiencing may be related to the way the measure is being evaluated in the context of the table and the slicer. When you add the URL measure to the table, it may be causing the table to evaluate the measure in a different context than the slicer, which can result in unexpected behavior.
One possible solution is to modify the measure to use the FILTER function instead of the SELECTEDVALUE function. This will ensure that the measure is evaluated in the same context as the slicer. For example, you could try something like this:
Item Link = VAR SelectedID = SELECTEDVALUE('List Directory'[ID]) VAR SelectedSysID = SELECTEDVALUE('List Directory'[SysID]) RETURN IF(LEFT(SelectedID,3)="ABC", CONCATENATE("https://www.somesite.com/nav_to.do?uri=tablename.do?sys_id=", SelectedSysID), CONCATENATE("https://www.somesite.com/nav_to.do?uri=anothertable.do?sys_id=", SelectedSysID) )
Alternatively, you could try adding the URL measure to the visual as a tooltip instead of as a column in the table. This will allow you to see the URL when you hover over the data points in the table, without affecting the filtering behavior of the slicer.
I hope this helps! Let me know if you have any further questions.
Thank you, this does appear to work as expected.
Hi @jmfillman,
According to your code, I think your measure will return different result based on different ID. I create a sample to have a test, and I think it should work.
Your issue should be caused by your data model, please share a sample file with me and show me a screenshot with the result you want.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
13 | |
6 | |
5 | |
3 | |
2 |