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.
I'm trying to create a calculated column that dynamically constructs a URL based on a value in the host table and the minimum and maximum dates in the filter context of the visualisation.
I'm running into problems because the filter context of the visualization doesn't work if I try to calculate minimum and maximum dates in a calculated column. It does work if I refer to a measure in that calculated column but then when I try and concatenate two measures in a column the filters are lost again. I have to use a calculated column because I want to the URL string to behave as a URL.
Is there a way around this problem?
// Works, filter context from the visualisation is applied Min Date Measure = FORMAT(min('MyTable'[Date]),"YYYYMMDD") Max Date Measure = FORMAT(max('MyTable'[Date]),"YYYYMMDD") Min Date Calculated Column = [Min Date Measure] Max Date Calculated Column = [Max Date Measure] // Doesn't work, filter context not applied so you get the min and max dates in the entire table MIN and MAX Dates Calculated Column = [Min Date Measure]&[Max Date Measure] //Doesn't work, because measures can't be formatted as a URLs MIN and MAX Dates Measure = [Min Date Measure]&[Max Date Measure]
Hi @edwardrmiles,
Based on my test, it seems there is no possibility to do that. As we all know, the calculated column values are static once it is created. Filter context won't affect the calculated column.
Regards,
Yuliana Gu
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |