I’m wondering how I would create a performance target and compare in Power BI.
eg. I’ve a table of transactions indicating the customer, region and sales.
I’ve summarized a table showing only Region and sales
Region Sales Sales % Target Sales % Difference
USA 200 66% 70% -4%
Canada 105 34% 30% 4%
How do I set the target sales % and get the difference?