Forum Discussion
power kpi matrix
- 8 years ago
Power KPI Matrix supports zero values now by enabling a toggle at Actual Value group of Formatting Panel.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
It's the same measure, just a different date (month). We are using direct query, row based Power KPI Matrix. When we format a parameter, e.g. gross profit so that it displays in the conventional format (e.g. $500,000), that formating is only being applied to that field on the month that was selected when the formating was done. So if the formatting of $500,000 was made with January 2019 selected, when we select February 2019, the same field now shows as 500000 (missing the $ and ,). If you return to January 2019 the filed displays as $500,000 again.
We are selecting the (each, individually) measure in the current value section of the format pane and applying the correct styling based on the field type, e.g. currency or percentage as well as managing the decimal places shown:
The only difference between the images above is that I have changed the date on the page.
Hope this helps to clarify
___________________________________________________________________________________________________________________
Update - We just tried the same report with Import, rather than direct query and the field formating appears to hold fine (from the testing we have been able to do). So the issue with the fields losing their formating only appears to be an issue with direct query. For us, direct query is the preferred approach for this report, rather than the import method.
Thanks for the explanation.
It is probalby a bug, but I have to check and reproduce it before add it to a visual backlog.
Could you please send us your report (to [email protected]) with fake data (if data are confidential) and connection through the import? It will help me to understand the issue better. I will change the type of connection on my side and will try to reproduce it.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]