Forum Discussion
power kpi matrix
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
v-viig v-evelk Hi team, loving the Power KPI Matrix. Quick question. In row based configuration, is there any way you can have the current value format settings hold (be maintained) across multiple months? We need to have a month selection in our balanced scorecard due to the nature of out business and the format customisations currently reset with each month selected.
E.g. If we configure a value such as Gross Profit to display (format) as $,0 (e.g. $500,000) in July 2019, if we select June 2019, the field is back to displaying 500000 (if it had the same value of course). To add clarity, the months which have been customised, do not lose their customisation, it's just that it is not applying to the field regardless of the date range selected so if we have the option of 24 months, we need to go in and format it 24 times.
We have had some success in selecting a very old date and applying the formatting, which sometimes carries through to all newer values, but it's hit or miss. Is there any way around this issue, or could we potentially see it sorted in a future release?
Thanks for your help!
Hi,
Do I correctly understand that you want that some custom fromatting automatically applies for new metrics that has been added recently? Is it the case?
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]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]
