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)
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.