Forum Discussion
Colectables by date reporting
I'm having a trouble with my visualization on powerbi desktop,
I created a dashboard on customer debts, with the aim of monitoring customer debts, and I created metrics to organize debts into columns 0-30 days | 30-60 days | 60-120 days|
When I generate the table view, the line does not respect the order of the columns and simply adds up all the values
formulas below:
How it's right now:
I can only see it organized when I add the document data to the line, but this is unfeasible as there are clients with +100 documents:
I aprecciate if anyone can help me, thanks 🙂
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523What is the DAX code for [DÃvida Pendente Moeda Original]?
01 - 30 Days = if([Difference Days]>=01 && [Difference Days]<=30, [DÃvida Pendente Moeda Original], blank())Please provide sample data that fully covers your question and describe the efforts you have already made in this table visual.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
