Forum Discussion
KPI Card Visual not behaving as expected
Hi team We're using the KPI Visual for our work Example of the data sitting behind Column ~ Measure (Calculated in PBI, not a field from the table) Week 1 ~ 50 Week 2 ~ 100 Week 3 ~ 150 ...
the card is showing value 150 as that is the current week, yet it's being coloured as yellow because the average of all weeks available is 100 - i want it to colour based on current week value. To get around this I created a new measure which only calculates the current week but the KPI card should've done this for me - no?
Hi, JamieLewis
It’s my pleasure to answer for you.
Could you mind providing some sample data with onedrive and your desired result?So we can help you soon.
Best Regards
Janey Guo
