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 Once you create the target table as mentioned above, you should be able to create above chart using power pivot. You can always analyze your model in excel using "Analyze in Excel" feature then create the chart you wish to have. Please try this option, you should be able to achieve it.
Thank you one more time. Will try and let you know asap. "Analyze in Excel" - is this a feature of PBI?
One more time i apologize if i sound incoherent, but i am working with PBI and power pivot since April 2020. Still pretty new to me...
Atanas