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.
I am working on Power BI Desktop and trying to use the tool - 'KPI Ticker by MAQ Software', which shows moving ticker per KPI name its current value and the variance to prior value.
My problem is due to the fact that the variance does not take into account that the observer may be interested in comparing two negative values. For instance:
Current Value = -69,5
Last Value = -281,6
How it should be calculated: [ -69,5 – (-281,6) ] / ABS(-281,6) = +75,32% (I am improving my result)
How it is currently calculated: [ -69,5 – (-281,6) ] / (-281,6) = -75,32% (It doesn’t make any sense)
Is there any possibility to adjust this problem in the visualization itself or is it really a mistake that must be corrected in a future software actualization?
Solved! Go to Solution.
Hello @gfluz94,
We have added your request to our backlog.
We will notify you on this thread when we update our visual with this modification.
Thanks
Hello @gfluz94,
We have updated KPI Ticker by MAQ Software to v3.3.3 with the calculation fix.
We recommend you to download the visual from marketplace and let us know your feedback.
Thanks.
Hello @gfluz94,
We have added your request to our backlog.
We will notify you on this thread when we update our visual with this modification.
Thanks
I am working on Power BI Desktop and trying to use the tool - 'KPI Ticker by MAQ Software', which shows moving ticker per KPI name its current value and the variance to prior value.
My problem is due to the fact that the variance does not take into account that the observer may be interested in comparing two negative values. For instance:
Current Value = -69,5
Last Value = -281,6
How it should be calculated: [ -69,5 – (-281,6) ] / ABS(-281,6) = +75,32% (I am improving my result)
How it is currently calculated: [ -69,5 – (-281,6) ] / (-281,6) = -75,32% (It doesn’t make any sense)
Is there any possibility to adjust this problem in the visualization itself or is it really a mistake that must be corrected in a future software actualization?
HI @gfluz94,
I don't think it is possible.
In my opinion, you can only replace all max value to absolute value at same time, it is impossible to replace part them in visual calculation.
Regards,
Xiaoxin Sheng
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 |
---|---|
96 | |
94 | |
82 | |
70 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |