Hi Concern,
Hope you are fine.
with referece of last KPI dashboard prepared below custom KPI visual, this time i need to show the difference value between actual and target on visual.
for example
Actual = 100,000 USD
Target = 80,000 USD
Difference = +20,000 USD (which i need to show on visual with %)
can you plz help me to acheive this objective with any solution available.
Regards...
WAQAR
92 333 3035810
Hi @waqar,
The value we can see from the visual is Actual value. Though we can add a measure of difference to the Actual value field, this could be confusion. Do you mean you want show up +20,000 USD in the visual? If so, I'm afraid this feature isn't supported by this visual.
Best Regards!
Dale
Hi Dale,
Yes, i want to show the differnce value on visual and respective percentage of actual over target.
Like visual show 20,000 (+20%).
Any other visual entertain this query ?
REGARDS...
WAQAR
Hi @waqar,
How about this Multi-row Card visual?
Difference = [SumActual] - [SumTarget]
%Difference = DIVIDE([Difference], [SumTarget],0)
Best Regards!
Dale
Hi Dale,
Hope you are fine, Any solution on my query.
REGARDS...
WAQAR
Apprecaite your effort,
i have 36 tiles on one page, multi row visual can work if we have only 2 3 visual on page.
I need a visusal to entertain my query without comprising my attached format.
REGARDS..
WAQAR
You can just create measures for this right? For example:
Difference = [Actual] - [Target]
% Difference = DIVIDE([Difference];[Target])
Thanks for your response, can you pls demonstrate it in files attached in below link
REGARDS....
WAQAR
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
123 | |
74 | |
66 | |
53 | |
53 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |