Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Dear Specialists,
I have a slicer with time frames (Yesterday, Fiscal Year, Last Quarter).
It's actually a bridge table that filters the date table.
Then I have a matrix visual.
Rows shows some dimensions data (countries eg)
Colums are the selected values (like yesterday, ytd etc)
value is for example sales amount
Now I would like to have two measures or even more, that always shows the var% of the first and second (third and fourth, fifth and sixth..) selected value.
Means:
I select YTD and Prior YTD in the slicer and in this first measure I get the variance between this.
I select current quarter, last quarter as number 2 and 3 and then I will get the variance of this in my measure2.
Actually I would like to reference certain values in selectedvalue() function.
Or anything similar.
Any idea? Or any other approach to get the var% in a variable way?
Thank you very much
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
11 | |
9 | |
8 | |
8 |