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!

[jeroenterheerdt]

I am not sure I understand your question. If you have the column in your matrix you can just write MAX([Column]) to get the max of the column in a visual calculation. Does that help?

[pablobarra]

This new feature is very good. I see that it allows calculations at the column level.
Is it planned to have calculations at the row level?

I am thinking of Profit and Loss reports where we want to see a value like EBITDA or Total Income or Margin.

[jeroenterheerdt]

thanks for the feedback. visual calculations are column only at the moment and we're not planning to have calculations at the row level at the moment.

[DanielBaretta54]

Eu fiz o gráfico e funcionou certo. Apenas quando foi publicado ele deu erro nos visuais que foi usado os cálculos visuais. Apresenta este erro "Não foi possível carregar os dados para este visual". Oque poderia ser?

[jeroenterheerdt]

I am so sorry about this. I am not sure what is going on. can you share some screenshots or errors maybe?

[aomsbansal]

I have couple of thoughts on Visual calculations:

1. How to use Visual Calculations with Field Parameters. I want to enable some calculations on visual based the selected value in field parameter. For example: I have a,b,c and d visual calculation on visual. I have setup a field parameter with slicer values a,b,c and d. 

So when a user select a and c from the slicer, user should see respective columns on visual. 

2. How it will work with matrix visual with nested columns. For example in below table i have Sales and Qty numbers for FY and FY-1 and i want to get (FY) + (FY-1) using visual calculations that would sum up the values of Sales and Qty for FY and FY-1. Is this currently supported?

	FY		FY-1		(FY) + (FY-1)
Country	Sales	Qty	Sales	Qty	Sales	Qty
India	43	5345	34	34	77	5379
China	545	64	545	64	1090	128
USA	34	43	34	34	68	77
France	6	645	64	43	70	688
Germany	46	454	34	54	80	508

[jeroenterheerdt]

hello, field parameters are not supported at this time.

[aomsbansal]

What are your thoughts about point 2? 
@jeroenterheerdt 

[jeroenterheerdt]

you should be able to do this with expand / collapse. Documentation is still being published for those.

[nielsvdc]

Hi @jeroenterheerdt ,

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

[Idrissshatila]

Hello @nielsvdc ,

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

[nielsvdc]

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

[jeroenterheerdt]

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

[jeroenterheerdt]

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

[Frankie_Vannini]

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)

[jeroenterheerdt]

can you maybe share a screenshot of what you're seeing and what you want to do?

[joris]

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

[jeroenterheerdt]

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

[wcarter]

This is a very cool feature, once conditional formatting is added (I use it on certain columns in a few matrix visuals) this will be a major performance boon for my reports that are aggregating and filtering millions of rows. The overhead of calculating a change % and doing it again for the formatting is a killer, moving that to the high-level view users see will be amazing.

[GGA]

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 😉

[mark_endicott]

@GGA - Hopefully this helps you with the Pareto analysis: