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 guys.
I am bit puzzled by a line chart extending out to next month when the next month value is not present.
The chart below shows Month-To-Date Actual (Bar) with Actual Cumulative (Line) in Jan 2020. There is not December and other prior month data so Jan only appears. What is interesting is that Feb appears in the Line Chart as if it is zero. In reality, Feb does not have any data just line Dec and prior months.
The following measures are used:
MTD Actual = IF(sum('Fact Summary'[MTD Actuals])=0, BLANK(),sum('Fact Summary'[MTD Actuals]))
hi @Anonymous
I have test on my side, it works well.
Could you please share your sample pbix file for us have a test, there should be something wrong in other.
Regards,
Lin
Have you checked to see which values are in FIN_YR_MONTH ?
Help when you know. Ask when you don't!
Yeah. It is just simple month and year.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |