Hi,
hope this is the right location for this post.
I have some questions regarding the KPI matrix 3.1.1 visual. It works great, but i struggle with some details:
- Collapse categories
is it somehow possible to disable this? - Category subtotals
Would be great to have an AVG option next to SUM and COUNT, e.g. to calculate AVG KPI % values - Sort order, categories
having the problem that if I use categories from dimension tables the visual shows all possible option of categories from those values. Currently i need to create a view on sql server to combine fact and dimension into one table (as documented in the sample) that gets imported to PBI to get this working correctly. Is there a way to get this working also with dimension tables?
Similar thing with sort orders: I've defined sort orders for categories in dimension tables. Because of not unique KPI names like "Availability" I'm not able to create a dimension table holding sort orders as in the example file. Is there a way to overcome this?
Thanks for your help