The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
My line chart shows monthly % of bad debt for Branch A, Branch B, Branch C.
Really appreciate your assistance on :
i) How to have a line in the chart to show Total % (Row Total in Green Font):
Total % for all Branches 1.9%(Jan), 1.5%(Feb), 3.3%(Mar), 1.3%(Apr), 0.9%(May), 1.1%(Jun), 1.1%(Jul), 1.5%(Aug), 1.5%(Sep).
ii) How to show Average % (Column Total in Red Font):
Average 1.7% for Branch A, Average 1.1% for Branch B, Average 2.5% for Branch C, 1.5% (Average for all Branches).
iii) Existing line chart is for month-to-month comparison.
How to have a measure and chart to show quarterly comparison? E.g. Jan to Mar'23 vs Apr to Jun'23 vs Jul to Sep'23.
New Measure: Bad Debt(BD)% =
Hello,
I am new to the Community and re-upload the images.
Really appreciate your assistance. Thank you very much.
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |