Share your thoughts on visual calculations (preview)

[jeroenterheerdt]

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!

[Brer_J_Cooper]

Hello,
For me, on Power BI desktop, it's working for most of my Table Visualisations on my report, but for one of the tables in its own page the "New visual calculation" button is greyed out and I'm not sure why.
Any suggestions?
Yours sincerely,
Jesse Cooper

[jeroenterheerdt]

hi, that is a bit weird. Is there any chance you can send me the pbix?

[Brer_J_Cooper]

Hello, unfortunately not, as it contains sensitive commercial data.
I rebuilt the table visual on a new page to match the previous table, and the new table has the button available. Strange, but it fixed my problem.

[jeroenterheerdt]

that is strange, but glad you were able to get it resolved.

[vlm_]

Great feature, but only works in Power BI Desktop for me((

Power BI Service shows "inf" instead of numbers in all cells.

Matrix, visual is 

Rate = IF(NOT(ISINSCOPE([Candidate])),FORMAT([Total] / PREVIOUS([Total],1,[Stage]), "Percent"), BLANK())

[jeroenterheerdt]

the feature works in both Desktop and the Service and this function call should return the same in both environments.

[lbendlin]

use DIVIDE to handle cases where you divide by zero or blank

[muturuf]

Hey Jay - as an ardent follower of yours; here is what I'd like to share.

In embedded power bi reports A SKUs (embedded in the web portal)

in the edit mode, when I select visual calculations, the Calculations bar does not show and it just hangs. In the field section it is added as hidden but I can't do much with it.

Visual calculations offer an incredible opportunity in our use case because it used to be that if any of the customers wants to a custom calculation it would always have to be that they would submit a request and then that measure would have to be added and they'd have to wait until the next deployment typically weeks away. So we are genuinely excited about Visual Calcs but only if they work in web-portal (A SKU) embedded dashboards 🙂

Thanks in advance.

[jeroenterheerdt]

Hi @muturuf thanks for checking in and asking this question. Visual calculations do not support embedded today unfortunately so this behavior is as expected at the moment. I would love to learn more about what you're trying to do though to help prioritize this. Can you send me a DM?

[andrew_k]

Hi Jay

I saw your Visual Cals presentation during the 'Power BI and Fabric Global summit', which brought me here. 
My use case is very simple. 
I have a Pro licence and and building personal Power BI reports so that I can showcase them on an online portfolio.
I use embedded so was surprised when my visual calc wasn't displaying.

I have since changed this but was interested if there was anything in the future pipeline to make them supported.

Kind regards, Andrew

[jeroenterheerdt]

Hi Andrew, thanks for checking in! Embedded is not supported (it's listed on the limitations): https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview#cons...
but will be in the future! Would love to hear how you've worked around it.

[andrew_k]

Hi @jeroenterheerdt 

Sorry for the delay in my response.
I managed to track down my report and in my case I had a very simple calc which I created as a visual calculation. Screen shot below.
To resolve the issue, I just copied and created it as a normal measure and added it to my visual.
I suspect that I only did it as a visual calculation to begin with to experiment and learn. So for me, it was no big deal to change it.

Regards, Andrew

[jeroenterheerdt]

ok, thanks for letting me know!

[than121711]

Matrix table with visual calculations does not display / throws an error when the dashboard is published to the web.

[jeroenterheerdt]

that is to be expected, since it's clearly listed on our limitations (https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview#cons... "You can't use the Publish to web functionality with reports that use visual calculations or hidden fields."

[mjc543]

Visual calculations and field parameters don't see to be very compatible with one another. I can create a visual calculation, but when I click 'Return to report' and try to go back into visual calculation edit mode, it's grayed out and I can't do anything else with it.

[jeroenterheerdt]

which version of Power BI Desktop are you using? We enabled the use of field parameters in the October release, so please confirm you are using at least that version.

[mjc543]

I am using the November 2024 release. 2.138.782.0 64-bit. I think that while field parameters were enabled last month, there's still some bugs that need to be worked out. Also worth mentioning in the affected line chart visual I am using a pair of field parameters on the Y-axis; 1 for the current value of the selected measure (with month/year on rows), and 1 for the previous value of the selected measure (same period last year).

[jeroenterheerdt]

can you share a screenshot please?

[mjc543]

Well, as luck would have it I've already closed the file, and when I reopened it, the problem went away. If I happens again I will try to capture it and share (along with steps to reproduce the error, if possible). Thanks for the quick replies!