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!

[kleigh]

Visual calcs could be used to offer an extension to the "Show Value As" option.

Alongside "Percent of grand total", it could offer "Percent of..." and allow any other numeric field in the row to be chosen.

I'm currently preparing a visual which is a set of percentages vs a baseline value. Previously, this required a lot of measures. Now, it can use visual calcs instead. This works, but the menu option would cut the clicks required to complete the task.

[Idrissshatila]

@VijayChinna , @swixglider  @Frankie_Vannini  @gregst 

and for all people that were asking on a way to format values in visual calculations, in the August Update it was added as an option that is visual level formatting

you can check these resources to know more about it and how to perform it
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

https://youtu.be/a6lI_B58wqQ?si=q8rdPO8xHI6gtlel

https://youtu.be/w1a55ujmEm4?si=xSJPaiYmQfuZQsD5

[jeroenterheerdt]

yep, and more is coming 🙂

[VijayChinna]

I'm trying to use it with a "Field Paramater" but it doesn't seem to work.
No options for formatting, ex: if we divide 2 measures for percentages to show on line chart as percentange (64.6%) or on tooltip is not possible

[jeroenterheerdt]

thanks for trying this out! Field parameters are listed as a limitation in our docs so they don't work yet with visual calculations.

[swixglider]

Thanks! That's a great new feature.

I'm trying to use it with a "Field Paramater" but it doesn't seem to work.

The option "New calculation" dissapear as soon as you add a field parameter to the table. Will it work in the near future? 

[jeroenterheerdt]

thanks for trying this out! Field parameters are listed as a limitation in our docs so they don't work yet with visual calculations.

[gregst]

Hello,

I've got an issue.

When I'm using fx to add the RUNNINGSUM I got the message below.
It referes to a column with the weeks. 
Whatever the measures I got this error

My table is quite simple

[jeroenterheerdt]

first of all, thank you for trying out visual calculations and I am sorry you weren't successful the first time around. I believe I understand what is going on here: the [Field] in the template is the numerical field you want to sum, so that's Snapshot in your case. RUNNINGSUM([Snapshot]) should work. Please try it and let me know if it works as expected. thanks again!

[gregst]

Hello
The error message is coming at the beginning, meaning when I click on "New Calculation" the error message is popping up.

The table is quite simple, I have the week and for this example I only put the measure Snapshot = 1

with a format as Whole number.

Even if I continue and create Calculation = RUNNINGSUM([Snapshot]) the screen stay with the error message.

The calendar I use to get the Week is linked with other table in my model. Could be the problem ?

I did several try and it seems the issue is coming only if I use the table "Calendar" 😞

[Frankie_Vannini]

Hi there

I've got a small vertical aligment issue the minute I use a unichar icon to display a negative or positive icon related to the value, waiting for conditional formatting option. This happens only using DIN Font bigger than 18 points

In essence I use this code for the visual calculation:

YoY % = 

VAR Curr = [ITEM]

VAR Prev = PREVIOUS([ITEM],COLUMNS)

VAR Result = DIVIDE(Curr-Prev,Prev)

VAR Color_Icon = if (Result >=0, UNICHAR(128994),UNICHAR(128308))

RETURN

if( Result = BLANK(), 

BLANK(),

CONCATENATE(

Format ( Result, "0.0% ") , ColorIcon

    )

)

the result is this one:

 

so using font DIN 14 on the left no significant vertical misalignement, while using DIN 34 I have a vertical misalignement. No issues with other fonts

By the way, any suggestion to change numbers in green or red using DAX and/or HTML?

Thanks

F

[gregst]

Hello again,
I solved my problem. The naming of the column seems weird for the New Calculation.
If I rename my column Calendar[ST Week] with ST Week all is working well.
Is it possible the square bracket [ ] create the problem ?

[jeroenterheerdt]

it's likely the 'Calendar' part that got confused as a table reference. In general I'd recommend not naming columns like that as Power BI is prone to think A[B] is a reference to a column B on a table A.

[abpgupta]

When I add Visual Calculation, export data option is gone so it looks more for adhoc reports but not reports where users are looking all features.

[jeroenterheerdt]

hello - export is not supported yet and is listed in our documentation as a limitation. We will enable export eventually.

[jfilhoul]

Need a lot that kind of export !! 🤩

[tara-erzi]

It's really amazing, thank you very much!
I was wondering if there is any code we can write for new calculations or something similar to change colors inside a single visual or customize the visual according to our needs. Some visuals have very limited options?

[jeroenterheerdt]

can you give me some examples maybe? You can already use format code and conditional formatting to format many things, but curious to learn what specifically you are looking for. many thanks!

[tara-erzi]

Thank you for your response.

I am currently using Facet Key and having several issues with it. While I found the solution to a similar problem helpful and managed to resolve the coloring issue, the colors still don't match my dashboard. I noticed that Facet Key has the capability to change colors based on category. 

[jeroenterheerdt]

ah thank you, the facet key is a custom visual so these will have formatting limitations or do things differently compared to built-in visuals.