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.
Hi everybody, I'm pretty new to Power Bi and I'm struggling with the following problem.
In our group, we receive by each country the balance of bank accounts (multiple account for one country) on a daily base.
This in theory, but in practice we have empty dates (different working days, skipped days...). So I have, for example, date for
If I create a line report, for example for the total balances I get a jumpy line (while if I do it by country, the system interpolates).
I need to avoid these jumps, so the system has to fill in empty bank accounts values based on the last one available.
I tried to follow the instructions available here, but I got an error on the definition of the [Date] column.
Here you can dowload the PBIX.
Any suggestion would be super appreciated!
Thanks
Marco
Hi @Anonymous
According to your description, my understanding is that you want to get data of continous date rather than the date like below:
In this scenario, we can create another continous date table and create relationship between them, then add the data in the date table to this visual.
Best Regards,
Teige
Hi @TeigeGao
thanks for the suggestion.
I try to explain further the need.
I want to add the rows in red in the table below (identical to the last day with available data, except for the date) so that when I draw the line chart of the total amounts (last 2 columns) with no detail by account/country ("€ bank balance worldwide" and "€ facility balance worldwide") it looks consistent (no holes).
Country | Bank Account | Date | € Bank balance of the day | € Facility balance of the day |
Argentina | a | 01/01/2019 | 4 | 5 |
Argentina | b | 01/01/2019 | 3 | 1 |
Argentina | c | 01/01/2019 | 8 | 2 |
Argentina | a | 02/01/2019 | 5 | 5 |
Argentina | b | 02/01/2019 | 2 | 1 |
Argentina | c | 02/01/2019 | 7 | 2 |
Argentina | a | 03/01/2019 | 5 | 5 |
Argentina | b | 03/01/2019 | 2 | 1 |
Argentina | c | 03/01/2019 | 7 | 2 |
Argentina | a | 04/01/2019 | 6 | 5 |
Argentina | b | 04/01/2019 | 8 | 1 |
Argentina | c | 04/01/2019 | 1 | 2 |
Argentina | a | 05/01/2019 | 9 | 5 |
Argentina | b | 05/01/2019 | 10 | 1 |
Argentina | c | 05/01/2019 | 12 | 2 |
I tried to do something similar to what you suggest: in the file you will find the table "Dates".
But it didn't work for me: in fact if I use that date and the € balance I get the result on the left, in the image, while I want the line to go through the point I draw (I choose a different date in the graph to make it graphically more clear):
If your solution works, I probably missed how it should be implemented: could you please explain further?
Thanks
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |