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