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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 21 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 13 | |
| 10 |