Forum Discussion
Share your thoughts on visual calculations (preview)
So I have the second strange behaviour
this graphic is generated in Desktop Version: 2.124.2028.0 64-bit (December 2023)
represents a YoY running totals created with DAX and is shown correctly. It also calculates the YoY variation a percentage through the tooltip
This is the same graph loaded with the latest version of PBI Desktop. Basically it has lost the cumulative and shows a simple YoY trend and also the YoY percentage change no longer works
This is the same graph created with the new Visual Calculation. The result is the same as the chart created with DAX but the line for the current year does not stop but continues straight ahead. Basically the chart counts the cumulative quantities up to the end of the month/year which are filtered through a slicer. So on the X-axis the days to the end of the selected month are shown, on the Y-axis the cumulative. Obviously for the previous year the line goes up to 0 i.e. the last day of the month, while for the current year the line stops at the current date i.e. -X days to the end of the month
it is weird to see that in the previous version the chart made using DAX is shown correctly, it is shown incorrectly if loaded as is with the new version, and it is shown correctly again when using the new Runningsum function
- jeroenterheerdt2 years ago
Microsoft Employee
can you please share the DAX for the measure and the visual calculation?
- Frankie_Vannini2 years ago
Advocate I
Hi there
sorry my fault. An error in the formula. It is weird the error didn't show up with previous PBI desktop (Jan 31, 2024 version)
- jeroenterheerdt2 years ago
Microsoft Employee
ok, thanks for letting me know!