Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm looking to implement a slicer that increases the values of my data in a chart. For example, a row with a value of 1000 would be increased to 1500 upon selection of the value 500 in a slicer, 1000 would increase the value to 2000, etc. How would I go about doing this? It would be even better if there was a way to manually input a number to increase the values by but it's my understanding that this isn't possible.
Thanks.
Solved! Go to Solution.
@StevenF19 Please follow below steps
1) Create a parameter
2) Create following measure
Calculated = SUM(Sheet1[Sales])+SUM('Enter Value'[Enter Value])
3)Use that measure in your report
PFA PBIX
@StevenF19 Please follow below steps
1) Create a parameter
2) Create following measure
Calculated = SUM(Sheet1[Sales])+SUM('Enter Value'[Enter Value])
3)Use that measure in your report
PFA PBIX
Thanks for your help. I used SumX with the parameter to achieve the desired result.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |