Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I am using the KPI Indicator custom visual (here) to display my metric evolution in time. The metric has a target value of 75 that I have included in the target value field, however, because it's a national metric, I want to avoid the target displaying when an Area filter is selected - so, basically, acting as if there was nothing on the "target value" field.
I have created this measure to switch the target value depending on the filter being selected or not:
TargetSwitch = IF( ISFILTERED(spain[achievement]), BLANK(),[Objective])
However, instead of eliminating the target value, it seems to have made it 0 (green color in KPI as it was still achieved, variance showing as +Infinity).
Is there a way to tell PBI that, when filter is on, a visualizartion field should be considered empty?
Edit: I just wanted to add that I have now tried the default KPI visual and I get the same result; obhective shows as blank, but colour is still green.
Thanks in advance
Solved! Go to Solution.
Hi @Booth070,
I'm afraid we can't do it that way. Because the calculation of KPI is in the background. The workaround could be that we can set the "target value" and "actually value" both 0. At least we can get a "0". I would suggest you create an idea here or contact the author of KPI indicator.
Best Regards,
Dale
Hi @Booth070,
I'm afraid we can't do it that way. Because the calculation of KPI is in the background. The workaround could be that we can set the "target value" and "actually value" both 0. At least we can get a "0". I would suggest you create an idea here or contact the author of KPI indicator.
Best Regards,
Dale
Thanks for your answer.
At the end, I have created two KPIs, one with and one without a target, superposed them and used the measure I created to control when each of them is visible, it does the trick but it's not ideal. I will submit the idea, thanks!
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |