topic Re: Share your thoughts on visual calculations (preview) in Desktop

Share your thoughts on visual calculations (preview)

jeroenterheerdt — Mon, 19 Feb 2024 18:27:26 GMT

Hit "Reply" and let us know what you think of visual calculations! To learn more about this feature, please visit the blog post or our documentation.

Here are some areas that we'd like to hear about in particular:

errors / issues you are experiencing
functionality that is missing / does not work as you expected that is not listed as limitations in our documentation.
suggestions on governance capabilities
sorting behavior of visual and visual matrix

Thanks and we look forward to hearing your feedback!

Re: Share your thoughts on visual calculations (preview)

Idrissshatila — Mon, 19 Feb 2024 20:02:09 GMT

Hello jeroenterheerdt ,

I saw people asking about value formatting.

Re: Share your thoughts on visual calculations (preview)

jeroenterheerdt — Mon, 19 Feb 2024 21:07:18 GMT

thanks, that is on the list of limitations which will be published in the docs (Tuesday)

Re: Share your thoughts on visual calculations (preview)

lbendlin — Mon, 19 Feb 2024 21:11:14 GMT

I think you may want to mention that in order to test this people would need to know to download the new Desktop version that was posted on friday, and that they need to enable it in the preview features section of the options and settings, and then restart Power BI Desktop. Of course it would be much nicer if the release would have been timed with the blog post!

Re: Share your thoughts on visual calculations (preview)

jeroenterheerdt — Mon, 19 Feb 2024 22:26:10 GMT

agreed!

Re: Share your thoughts on visual calculations (preview)

Frankie_Vannini — Tue, 20 Feb 2024 06:14:45 GMT

Hi there, Ii don't know if this is related to the new version or to visual calculation but I

have a couple of strange behaviours that i didn't have in the previous versions. The first concerns the use of the Ciclet Slicer version 2.1.10. As you can see, in the desktop version the text is visible, in the web version the text disappears completely or partially. This did not happen with all versions prior to this Version: 2.126.927.0 64-bit (February 2024)

Re: Share your thoughts on visual calculations (preview)

Frankie_Vannini — Tue, 20 Feb 2024 07:35:33 GMT

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

Re: Share your thoughts on visual calculations (preview)

rkapil — Tue, 20 Feb 2024 08:30:11 GMT

2 suggestions to add in documentation -

1. Governance - Centralized measures in model helps in reusability across various reports so there should be a fine balance between what to use when

2. Few example use cases where Visual Calculations will be game changer - e.g. Building Income Statement, etc

Re: Share your thoughts on visual calculations (preview)

GGA — Tue, 20 Feb 2024 09:59:34 GMT

Hello jeroenterheerdt

From my quick tests the two mains limitations I experiment is that
- it's not compatible yet with Field Parameters
- I am trying to replicate ABC Calculation (pareto) but it's not possible as we need to order by quantities ascending

Otherwise this new feature seems promising. thanks for the hard work 😉

Re: Share your thoughts on visual calculations (preview)

joris — Tue, 20 Feb 2024 14:16:35 GMT

I'm missing the ability for conditional formatting. Does it work differently, or will this be added later?

Re: Share your thoughts on visual calculations (preview)

Frankie_Vannini — Tue, 20 Feb 2024 14:29:43 GMT

Just 2 questions:
Is it possible to calculate the YoY % or MoM % trend, while I have the year/month as a legend in the graph?
in the runningsum calculation, if I have a YoY comparison is it possible to show in full data related to last year while only YTD/MTD for current year? (to avoid to have a flat line with latest value until the end of selected period)

Re: Share your thoughts on visual calculations (preview)

jeroenterheerdt — Tue, 20 Feb 2024 16:26:45 GMT

will come - it's on the list of limitations.

Re: Share your thoughts on visual calculations (preview)

jeroenterheerdt — Tue, 20 Feb 2024 16:27:15 GMT

field parameters are not supported yet. can you show me exactly what you're trying to do with the pareto?

Re: Share your thoughts on visual calculations (preview)

mark_endicott — Tue, 20 Feb 2024 16:27:30 GMT

GGA - Hopefully this helps you with the Pareto analysis:

Re: Share your thoughts on visual calculations (preview)

jeroenterheerdt — Tue, 20 Feb 2024 16:27:51 GMT

this is not related to visual calculations, I suggest opening an issue separately for this to get help.

Re: Share your thoughts on visual calculations (preview)

nielsvdc — Tue, 20 Feb 2024 19:28:22 GMT

Hi jeroenterheerdt ,

Currently the visual calcualtion documentation links mentioned in your visual calculation and the monthly Power BI blog posts are still unavailable.

Re: Share your thoughts on visual calculations (preview)

Idrissshatila — Tue, 20 Feb 2024 19:31:23 GMT

Hello nielsvdc ,

check this https://powerbi.microsoft.com/en-us/blog/visual-calculations-preview/

Re: Share your thoughts on visual calculations (preview)

nielsvdc — Tue, 20 Feb 2024 19:33:29 GMT

I know. But for example the link mentioned in the post for the RUNNINGSUM function is not working.

Re: Share your thoughts on visual calculations (preview)

jeroenterheerdt — Tue, 20 Feb 2024 22:18:45 GMT

the docs are still coming online, but I expect those to start working soon.

Re: Share your thoughts on visual calculations (preview)

jeroenterheerdt — Tue, 20 Feb 2024 22:19:29 GMT

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview