Forum Discussion
Power KPI Matrix - Current value and card dont match for same measure (multi date select slicer)
Hey all, just looking for some assistance. I'm using the Power KPI Matrix visualization, and things are working mostly well. One problem I'm having is when selecting multiple months on my date slicer. The Power KPI matrix displays a different value than another card visual I've used just for reference. They are both assigned the same Measure.
When selecting multiple months, the card visual aggregates properly and gives me the average rate for all selected months. The Power KPI matrix visualization is just giving me the singular rate for the most recent month in that selection. I.e. if I select months 1,2,3, and 4, it only shows the value for 4 where the card shows the average/aggregated value for all 4.
See the "MC Rate" in the image. they are both the exact same "MC Rate" measure, and I dont understand why they are showing with different values. Thank you in advance