Forum Discussion
Showing incorrect values when slicer is selected
Hi, I have defined parameter from 1 to 100 called as threshold value. I created a new column and that column I have used in a slicer. But when I select " At above Threshold"-it shows both the values "At above Threshold values" and "Below Threshold values", but when we select Below Threshold or No change, it shows the correct values for both. Here, I selected "At Above Threshold"-Green color indicate-Below Threshold, Red color indicate-At above Threshold, Grey color-No Change.
What I am doing wrong here? Any Solution?
Measure for new column-
Calculated columns are only calculated during data refresh, so they pay no attention to slicers and filters. To respond dynamically to slicer changes you need to create a measure instead. try
Filter threshold = IF ( SELECTEDVALUE ( new_nds_release_diff_ds[Metric_value] ) - SELECTEDVALUE ( new_nds_release_diff_ds[old_Metric_value] ) = 0.00, "No Change", IF ( 'Difference % Threshold'[% Diff] >= SELECTEDVALUE ( 'Difference % Threshold'[Difference % Threshold] ), "At/Above Threshold", IF ( 'Difference % Threshold'[% Diff] < SELECTEDVALUE ( 'Difference % Threshold'[Difference % Threshold] ), "Below Threshold" ) ) )this is assuming that [% Diff] is a measure.
2 Replies
johnt75Super User
Calculated columns are only calculated during data refresh, so they pay no attention to slicers and filters. To respond dynamically to slicer changes you need to create a measure instead. try
Filter threshold = IF ( SELECTEDVALUE ( new_nds_release_diff_ds[Metric_value] ) - SELECTEDVALUE ( new_nds_release_diff_ds[old_Metric_value] ) = 0.00, "No Change", IF ( 'Difference % Threshold'[% Diff] >= SELECTEDVALUE ( 'Difference % Threshold'[Difference % Threshold] ), "At/Above Threshold", IF ( 'Difference % Threshold'[% Diff] < SELECTEDVALUE ( 'Difference % Threshold'[Difference % Threshold] ), "Below Threshold" ) ) )this is assuming that [% Diff] is a measure.