Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am new to power BI and trying to create a useful graph to show again per customer in a graph. So essentially 1 bar per customer and the bar total is the total amount broken down into 0-30 section, 30-60 section, and 90+ section. I have data currently in a table that has invoice number, customer name, invoice date, due date, and amount. I also want to be able to hover over each section of the bar and get a quick pop up showing total $ and # of invoice. Can anyone help me out. I attached a snap shot of the table that i have.
[IMG]http://i67.tinypic.com/24g1w9e.png[/IMG]
Solved! Go to Solution.
@bouyazbekj add new column in model for aging days,
Aging Days = VAR days = DATEDIFF( Table2[Due date], TODAY(), DAY ) RETURN SWITCH ( TRUE(), days >= 91, "90+ Days", days >= 60, "60 - 90 Days", days >= 30, "30 - 60 Days", "0 - 30 Days")
On stacked bar chart, add customer on x-axis, aging days as legend and amount outstanding as value and you will get the chart
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
If you can paste that sample data as text that would be great. I don't want to type all that. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg,
Sorry about that. Can you work with something like this?
Customer | Invoice | Invoice date | Due date | Amount outstanding |
Forge | 11521 | 15/5/2018 | 09/06/2018 | $ 83,000.00 |
Dinerian | 11560 | 23/05/2018 | 15/06/2018 | $ 23,000.00 |
CPG | 11570 | 31/05/2018 | 18/06/2018 | $ 12,562.00 |
CPG | 11590 | 13/06/2018 | 12/07/2018 | $ 12,578.00 |
Cenovous | 11666 | 11/07/2018 | 02/08/2018 | $ 93,215.00 |
ARC | 11672 | 12/07/2018 | 05/08/2018 | $ 22,188.00 |
ARC | 11690 | 17/08/2018 | 01/09/2018 | $ 2,369.00 |
ECA | 11778 | 27/08/2018 | 18/09/2018 | $ 21,248.00 |
ARC | 11779 | 27/08/2018 | 13/09/2018 | $ 698.00 |
ECA | 11900 | 01/09/2018 | 29/08/2018 | $ 2,248.00 |
ARC | 11200 | 31/10/2018 | 24/11/2018 | $ 24,548.00 |
BTE | 13554 | 31/10/2018 | 26/11/2018 | $ 2,266.00 |
BTE | 12697 | 31/10/2018 | 30/11/2018 | $ 88,963.00 |
ARC | 12358 | 30/9/2018 | 01/10/2018 | $ 9,948.00 |
ECA | 15885 | 25/10/2018 | 16/11/2018 | $ 14,488.00 |
FRA | 16015 | 2/12/2018 | 22/12/2018 | $ 15,458.00 |
@bouyazbekj add new column in model for aging days,
Aging Days = VAR days = DATEDIFF( Table2[Due date], TODAY(), DAY ) RETURN SWITCH ( TRUE(), days >= 91, "90+ Days", days >= 60, "60 - 90 Days", days >= 30, "30 - 60 Days", "0 - 30 Days")
On stacked bar chart, add customer on x-axis, aging days as legend and amount outstanding as value and you will get the chart
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |