Forum Discussion
KPI Visual and SUM
I'm trying to create a dashboard that shows Monthly performance vs Targets. However, when I create a KPI visual, the Value defaults to 'Sum of..' and there isn't a 'Don't summarise' option available. Currently, my KPI below (see screenshot) shows the Yearly total (Jan-Dec) vs Yearly Target, instead of January Actual vs January Target. I'm quite new to Power BI and would really appreciate your help with this! 🙂
5 Replies
Hi eladumitrascu
It looks like your top filter is not filtering the data in the card visual.
Can you please check the interaction between filter and card visual
Please read the article
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktophttps://www.youtube.com/watch?v=gcCs44BYB_0
When you selected filter as January, your card visual should show January data
Hi there, thanks a lot for your help. I've just checked the setting and the filter is already set to apply changes across the entire page (see screenshot) . The data still doesn't change when I click on January.
For your reference.
Have you set up a relationship between the date table you're using in the slicer and the table that contains the Metric1 data?
Hi there, yeah they're all connected using Month as a common key
Is "1.Calendar_PowerQuery" a fact table or dimension table?
I think the relationship arrows should be reversed...
