Forum Discussion

FarhanMalik's avatar
FarhanMalik
Frequent Visitor
5 years ago
Solved

Traditional Financial Statement Tables in Power BI by using Python Visuals is possible?

Hi All,

I adopted using power BI as go to tool for financial planning and reporting purposes. As part of the routine work, our stuff involves making lots of pivoted tables instead of graphs. Coloumns like PY, BP, Actual, Actual vs PY etc. Each line has seperate formatting requirement. For example revenue would be a whole number, Earning per share would be a decimal number and Gross Profit margin would be a %age. Similarly their variances have different formatting requirements. Like when a an abs number is compared, comparison number should be in % but when a margin is compared comparion should be formatted as "x.x p.p". All variances need to be color coded (green good & red bad). 

Currently i am using mix of calculation groups, matrix visuals (infact two visuals grouped as one) with power BI conditional formatting applied to the output. Its not elegant & has performance issues sometimes but its working. 

However, I would be greatful if you can suggest that how Python visuals (sorry i am totally oblivious of python funcationalites) specially the famous pandas can help create such visual? Since python can do anything a spreadhseet can & producing such table is everyday excel stuff - so if there is a technique or direction i should look into, please do advise.

Thanks a lot in advance for your help. 

4 Replies