Dynamic KPI Targets

[Maria_Ga]

Hello, I've been searching for a solution and i can't seem to find it. I've been working with power pivot for the last three months.

My metric named A% is the result of the following calculated field = CALCUALTE(Divide([Reduction in margin], [total Net revenues])).

I have quarterly targets for A% - absolute number for the last 5 years. This is Q1 FY15 5%, Q2 FY15 6%, so on..

How can i create the KPI that is linked to my table with the quarterly targets? Hope anyone can help! Cheers

[v-yulgu-msft]

Hi @Maria_Ga,

Do you mean you are trying to create a KPI visual with dynamic targets in PowerBI desktop? What is dynamic KPI targets in your scenario?

If you mean the KPI target should be dynamically changed based on selection (Q1 FY15 , Q2 Fy15, etc), please refer to this article: Compare KPI to a Custom Defined Baseline in Power BI

If I misunderstood your requirement, please share some sample data and screenshots to describe how you create your report and what is your expect output.

Thanks,
Yuliana Gu

[Maria_Ga]

Hello Yuliana, Thanks for contacting. In the attachment you will find what i am envisioning.

You will see my power pivot table transformed to values and a screenshot of how actually looks. I have slicers that filter these results by Geo, by dollar amount and others.

So i have my CoPQ% metric (actual results) which needs to be compared against two targets: one called "Plan" and another called "Target". These two are set every quarter by Geo and by Fiscal Year.

In the second table below I'm showing what I'm after. i would like to set two KPIs (one for Plan and another one for the Target) against the measure CoPQ% and have the status displayed with coloured icons.

On table three you'll find the targets (Plan & Target) for only one Geo. But in reality i have more than 15 geos for more than 5 fiscal years.

Hope this helps,

Kind Regards