Forum Discussion
Power KPI Matrix: Can't set comparison value
It seems the latest version has not been loaded. Do you have a stable internet connection?
Please try to load the latest package from AppSource and import it into your report.
As a workaround you can apply setting but do not close the panel.
Just press save and reboot the report.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
I am using version 2.2.1.0, although it has a release date of 12/7/2018, and it continues to exhibit the described behavior.
Version 2.2.1 is deployed to producation.
Have you tried to clear browser cache and try again?
If issue is still reproduciable we ask you clear browser cache and capture network traffic by using Chrome Dev Tools -> Network.
Network session will help us in understanding this issue.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Just to be clear, the problem is occuring in Power BI Desktop. The scenario is as follows:
1) Measure added to actual value.
2) Measure added to comparison value.
3) Open column mapping window.
4) Comparision value is selected.
5) Click apply.
6) Comparison value appears in matrix.
7) "Back to Report" selected.
8) All comparison values disapear.
The workaround of saving before going back to report, closing the application, and reopening does work - but that is clearly not the desired functionality.
I did try clear the browser cache, with no effect. Could you explain why capturing network traffic would be relevant?
If you use Power BI Desktop you should remove its cache by removing everything at these directories:
-
C:\Users\%username%\AppData\Local\Microsoft\Power BI Desktop
-
C:\Users\%username%\Microsoft\Power BI Desktop Store App
-
C:\Users\%username%\AppData\Local\Microsoft\Power BI Desktop SSRS
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
-
Sorry,
This did not resolve the problem.
I am running desktop version 2.65.5313.701
It seems the latest version has not been loaded. Do you have a stable internet connection?
Please try to load the latest package from AppSource and import it into your report.
As a workaround you can apply setting but do not close the panel.
Just press save and reboot the report.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hi there.
I'm here just to report that I've just updated the visual with the 2.2.2.0 version (stated as uploaded on Dec. 26th) and I report that the bug mentioned at the begining is gone.
On a aside note, it seems that the visual can't handle comparison values that are set do 0 (like a variance that should be 0 but can be percentually negative or positive). Is it like that or is it a bug? If it's a bug, then I'll open another topic so that this one can be properly closed and the "new" bug can be properly traced.
Happy to hear that.
Zero values for comparison values are not supported since they cause an error of dividing a number by zero.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
I just got around to updating to 2.2.2.0 and the bug is resolved. Thanks.
Happy to hear that.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
