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,
I created a line chart to show the balance movement on a daily basis, comparing few months trends.
For some dates the data is missing, so I added the formular to add zero and used a day in the chart from the manually created calendar table. The problem I have is I only have the data up to the 15th of March and the calendar dates are up to 15th of March, but on the line chart I have a can see the line until 31st of March.
How can I stop the March line at the 15th?
Below is the dax formular for total balance and charts
Thanks
Are you using a Date Dimension? If so, have a column for the Day Number, for example..
DayNum = DAY([Date])
Then create a another column that you can filter (could use a measure as well)
Is Day Num before Today = IF(DayNum <= DAY(TODAY()), "Yes","No")
On your chart add the "Is Day Num before Today" and then select "Yes".
Yes, I'm using the date dimention and added additional columns. Unfortunetly the latest month is still showing the line until the end of the month. Possibly need to add day and month.
Can you share some screenshots so I can see what is happening?
Hi.
I don't have the data for the last day of the month, that is why in the measure I add 0 to the sum of balance. Then link the date to the calendar table and use the calendar date in X axis.
Without adding a zero the chart look like this, so the end of the month 31st or 30thth is missing.
With the zero it looks like I want, but the latest month has future days populated.
With the new day formulars the chart breaks at just over mid month
Try removing 0 from measure.
Without 0 the chart stops at day 30, but I want to show the dip on the last day
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
53 | |
46 | |
16 | |
12 |