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 would like to capture the value selected in the slicer and use that value in the further calculation. For example, if the user selects the year 2015 and a particular event in 2015, along with 2015 data, I also would like display 2014 data for that particular event.
Appreciate any inputs.
Thanks in advance!
Kishan
Hi @kishu2012,
To achieve this requirement, you need to create a dynamic calculated column, the column value should changed along with the selected items in slicer. However, calculated column value is calculated when your power report initially run, and will not be re-calculated no matter which itmes you selected in slicer. So currently, I am afraid your requirement cannoe be achieved. Thank you for your understanding.
Regards,
Charlie Liao
Previous Year Measure = CALCULATE ( SUM ( Table[Value] ), PREVIOUSYEAR ( CalendarTable[Date Column] ) )
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |