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!

[Branca32844]

Hi! 
I wanted to use Visual Calculations with Field Parameters as measures, not dimensions.
So, I have a measure slicer where I can pick the measure I want to display, and wanted to create a Y axis Max visual calculation. It seems to grab only the measure selected, and not the Selectedvalue of the field parameter. So when I switch the measure, it gives an error, as the VC is not able to change dinamically along with the FP.

Is there a solution for this? 
Thanks a lot!!  

[jeroenterheerdt]

Hi, thanks for chiming in! This is expected behavior at the moment since when you switch out the field parameter value the selected measure actually disappears from the visual. There is no way to get the selected value of the field parameter unfortunately.

[Branca32844]

Thanks for the speedy response!

When you say "at the moment", this means it would eventually get solved? Is it on the roadmap? 

[jeroenterheerdt]

what I meant is that we are aware but haven't found a solution we like yet. It's on the roadmap, but I don't have a date to share.

[Gepax]

I found an alternative… Ideally, it would work natively with the field parameter, but this is what I managed to do.

I manually created a field parameter:

prm_M_Tipo_Combustivel =

    DATATABLE(
        "Tipo",

        STRING,

        {

            {"Diesel"},

            {"Arla"}

         }

     )

After that, I created a measure that uses “Measure A” if “Diesel” is selected, or “Measure B” if “Arla” is selected.

I used this measure in the visual, created a moving average (visual calculation), and it adjusts according to the selected option.

[jeroenterheerdt]

got it, yes that works, but it's a workaround. Ideally this should work more directly. Thanks for sharing!

[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.

[bluehenve]

I just had this issue today in a table visual, and found out that "Show items with no data" makes the VC button grey out. I see now, that it mentioned as a limitation in the documentation. Maybe you could add a popup on the VC button explaining why its greyed out, because it was really frustrating to figure out the reason?

[jeroenterheerdt]

I am glad you found our rather long list of limitations. It's the source to go to to learn about them. We considered adding something for these limitations, but since they should be resolved eventually we didn't think it was worth the effort.

[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!