Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
Hi @FarhanMalik
Power bi can do you good if you are not familiar with Python. In Power Bi you can get visuals or customize your own visuals https://docs.microsoft.com/en-us/power-bi/developer/visuals/power-bi-custom-visuals
I made a Financial statements report, please take a look
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @FarhanMalik ,
Here are some documents for your reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals
https://towardsdatascience.com/using-python-in-power-bi-ee95a6b71443
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi thanks for sharing. Have you used custom visual in your sample income statement report?
Hi,
I had quick tried it once but never used it. Didn't need to.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @FarhanMalik
Power bi can do you good if you are not familiar with Python. In Power Bi you can get visuals or customize your own visuals https://docs.microsoft.com/en-us/power-bi/developer/visuals/power-bi-custom-visuals
I made a Financial statements report, please take a look
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
119 | |
78 | |
58 | |
52 | |
48 |
User | Count |
---|---|
170 | |
117 | |
63 | |
58 | |
51 |