Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to create a dynamic column that will reflect a percent change from a total amount. I would like to be able choose a percent change of "Total Charge" from the slicer on the left that would then reflect in the data columns on the right.
Is it possible to have one column (to the right of "Total Charge") that could change based off of my slicer to show the percent change of the "Total Charge" value? I have already created measures in this table that do this calculation, but would like only one measure to show up at a time based off of the slicer selection.
Solved! Go to Solution.
Hi @Anonymous ,
I assume that the % is a table that you have correct?
You need to add the percentage values to that table it has to look something like this:
% Category
-0,1 | 10% Decrease |
0,1 | 10% Increase |
-0,25 | 25% Decrease |
0,25 | 25% Increase |
-0,05 | 5% Decrease |
0,05 | 5% Increase |
0 |
Baseline |
Then add the following two measures:
Selected % = SELECTEDVALUE(Percentages[%]) Total adjusted = IF ( COUNT ( Percentages[%] ) > 1; "Need to select only one percentage value"; SUM ( Revenue[Total Charge] ) * ( 1 + [Selected %] ) )
Then add this measure to your table, check the result on the PBIX file attach.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
I assume that the % is a table that you have correct?
You need to add the percentage values to that table it has to look something like this:
% Category
-0,1 | 10% Decrease |
0,1 | 10% Increase |
-0,25 | 25% Decrease |
0,25 | 25% Increase |
-0,05 | 5% Decrease |
0,05 | 5% Increase |
0 |
Baseline |
Then add the following two measures:
Selected % = SELECTEDVALUE(Percentages[%]) Total adjusted = IF ( COUNT ( Percentages[%] ) > 1; "Need to select only one percentage value"; SUM ( Revenue[Total Charge] ) * ( 1 + [Selected %] ) )
Then add this measure to your table, check the result on the PBIX file attach.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis is exactly what I was looking for. Thank you!
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |