Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |