I have below data:
Month Total new customers
When using KPI control, 5 is displayed. Can i display 30 instead of 5? I need this because i must keep cool-trends in the background of KPI. But i do not want to display 5, i want to display 30.
How can i do that?
Go to Solution.
If you are looking for the total you will need to add a measure that aggregates the "total new customers"
TotalCustomers:=Sum('Table1'[Total new Customers])
just change the name of table1 to your table.
then link the measure to the KPI visual.
Thanks. Let me try
@Dog: It does not work. After doing this, it is still 5
do you have anything on the report page that is applying a filter. If so but you still need to display the full total regardless of filters you can edit the measure or create two to keep it simple.
CountofCustomers:=Sum('Table1'[Total new customers])
this should prevent any filtering on table 1 (your table) to amend the results.
I have the same problem but this solution doesn't work
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!