Forum Discussion
Power KPI Matrix - Inconsistent Formatting
It seems that i didn't tested it properly and after saving and reopening the file i could set the formatting without many problems.
The way it works is that you have to manually set the formatting for each combination of filters, and it will store the last 20 combinations? On the following gif i have set formatting (Current Value) for No filtering and for year 2018. Ignore the empty KPI Status (no data)
Are you testing in Power BI Desktop?
PBI Desktop is for editing only. That means Power KPI Matrix uses current filter + settings set.
If you want to persist settings in Edit mode you should enable Format Panel -> Table -> Keep Series Settings On Filtering In Edit Mode.
If this option is enabled you won't be able to change settings.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
How could i save format setting set for that 20 combination filters in column based table ?
if i have 2 slicers: one is to swith between current month data and year-to-date data, second is to swith between country.
Then, power KPI Matrix shows KPI by company of country selected and current month or ytd selected, which number of company in each countries does not equal. column layout will get back to default when i swith slicer selected and it's small that i cant see amount inside.
Hello,
Have you enabled the option "Kepp Series Settings On Filtering In Edit Mode"?
Could you please clarify your issue, provide screenshots?
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]i've found the solution by clearing all filter, then arrange the format layout manually in each columns while "Kepp Series Settings On Filtering In Edit Mode" is Off. Thus, column witdth are fixed when i select any slicer.
thank you for reply.
Hi I am having a similar issue where I am not allowed to change the formatting for a particular row of a kpi power matrix. I have 4 rows of data, for the first two, I would like the auto-formatting for the display units (or I can fix the units also), for the last two I would like no formatting. I can change the first row to Auto, but cannot adjust the second row. It simply changes the value back. I did turn off the Keep Series Settings thing. If I clear all filters, it allows me to change the settings, but as soon as I select a filter again, it switches back to No formatting for display units- only for that one row, the first row still keeps its formatting. I even remade the graphic with no filters at all, changed the display units formatting to be what I wanted, and then when I added one of the filters, the units formatting changed back to None. BTW- the values displayed in the different rows all have the exact same formatting in the dataset itself.
