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 have a situation in which I am attempting to perform a dynamic variance calculation of year on year revenues based on the selection of two separate slicers (year). I can calculate the variance with the year as a fixed variable; however, the fact that the different slices are based on the same year field but different values of that field are presenting a challenge when attempting to make it dynamic.
Calculating the revenues isn't a problem as I can isolate the slicers to the cards by which to perform the calculation. However, I would also like to provide the end user with the ability to choose the years by which to perform a dynamic variance calculation.
Revenue (Year1) - Revenue(Year2) = Variance
I hope that makes some sense.
Any help or recommendation would be greatly appreciated!
Thanks!
Solved! Go to Solution.
Of course. I ended up creating a duplicate connection to the SQL view that I was using. By duplicating the data set, I was able to truly differentiate between the data that was being filtered via the multiple slicers.
This challenge has been solved.
Hi @aschwanbeck,
Glad to hear that it has been resolved by yourself. Would you please share the solution so that it can benefit more users?
Thanks,
Yuliana Gu
Of course. I ended up creating a duplicate connection to the SQL view that I was using. By duplicating the data set, I was able to truly differentiate between the data that was being filtered via the multiple slicers.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |