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.
Hi All,
I have 3 visuals in my report and one gets filtered based on the Year filter that i have from a unrelated table.
But the other two visuals dont get filtered based on this year filter.
Any idea how can i make them filtered without having a active connection between table1 and year table?
Solved! Go to Solution.
@Anonymous
You can use in values() for unrelated tables with selectedvalue(), e.g.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Assumed year is disconnected table
measure =
calculate(countrows(Table), filter(Table, Table[Year] in values(Year[Year])))
measure =
calculate(countrows(Table), filter(Table, Table[Year] in allselected(Year[Year])))
or
measure =
calculate(countrows(Table), filter(Table, Table[Year] in values(Year[Year])))
want to plot on visual
measure =
calculate(countrows(Table), filter(Table, Table[Year] = max(Year[Year])))
@amitchandak Thanks Amit.
But i think i need a selector kind of measure to apply it on the visual
For example, if(selectedvalue( year[year])=query1[year],1,0)
but not sure if this is the right way to write
Hi all,
any thoughts about it please... please...
@Anonymous
You can use in values() for unrelated tables with selectedvalue(), e.g.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |