Forum Discussion
Reporting Performance to Target
I managed to do it. Please see below:
1. I created calculated column only for my past due balances.
2. After that another one I named "Fraction of the Overdue" with few nested ifs. If month =9 then overdue column * 0.055, if month = 10 then overdue column * 0.05 etc.
3. I created 3rd column dividing the Fraction of the Overdue to the Overdue column.
4. Put it in the pivot table, but summerizing the value to Average
5. Done.
This is how my pivot looks now. Exactly as I wanted it.
negi007 I would really want to thank you for your guidance and support.
Wish you nothing but the best.
Take care and stay safe.
All due respect,
Atanas
Anonymous
In this case you will need to create one more table for target values. let say below are two tables you have one is actual value and one is target value table. In target table mentioned value against first day of the month.
2. You create one date table, in case you do not have it like below
3. link your target and actual value table using date field
4. You can create below visual once your data is ready
Thank you very much for the answer and the suggestion!
I don't know if you noticed, but as of now I am using Power Pivot and not Power BI.
At this point I cannot create the same chart as you did in PBI.
This is how my pivot looks as of now in order to create the chart from my original post:
I was wondring if not possible to change the target with DAX functionallity so the Pivot shows the target as below (please note i added the new numbers manually)
Do you have any suggestion about that?
Thank you one more time,
Atanas
Is it possible if every citizen's column is gived a target per month?
