The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I am using card with states visual to visualize percentage change of target over the measure i.e. variance%. The formula I have observed in card with state visual to calculate percentage change of target over measure is ((measure-target)/measure)*100. Is there any trick to convert it to ((measure-target)/target)*100.?
Can anyone please provide solution on this.?
Regards,
Prasad Kulkarni.
If you already have a measure, why not change the measure directly by replacing measure with target in the original measure formula.
Best Regards,
Herbert