Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jeroenterheerdt
Microsoft Employee
Microsoft Employee

Share your thoughts on visual calculations (preview)

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!

173 REPLIES 173
gregst
Frequent Visitor

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

gregst_0-1718296589357.png

My table is quite simple

gregst_1-1718296852456.png

 

 



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!

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" 😞

 

gregst_2-1718696815345.png

 

gregst_3-1718696864658.png

gregst_4-1718697254634.png

 

 

 

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:

DIN Visual Calculation.png

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
Frequent Visitor

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 ?

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
Continued Contributor
Continued Contributor

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.

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

Need a lot that kind of export !! 🤩

tara-erzi
Frequent Visitor

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?

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!

Facet Key.jpg

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. 

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.

Chita
Microsoft Employee
Microsoft Employee

Hey! It's really a great feature. I think it would be more helpful if we can filter these new visual calculation columns in visual filter panel. 

agreed - filtering on visual calculations is not yet possible and a documented limitation.

Schrage
Frequent Visitor

Really appreciate this option. Smashing the like-button. Two items that would be super helpful: 

  • Conditional Formatting (looks like you are already tracking that)
  • A way to view the underlying low-level functions so it makes it easy to add to the model. I have a difficult time contextualizing the context in which I want to view things - being able to create a visual using these simple ones would go a long way to helping me execute more efficiently. 

Thanks again - I appreciated your YouTube video!

thank you - can you elaborate a little bit more on the second point maybe? Am I correct in understanding you'd like to see a way for you to see the window function (such as window/offset/index) you'd invoke if you'd wrote the visual calculation as a measure?

Correct, it may not be feasible, but I'll give an example:

  • I have a YoY chart calculating sales by Fiscal Year. Using the SAMEPERIOD function in a measure on the same table, I get slightly different numbers because our fiscal years don't align YoY. 
  • I know there are probably ways to solve for this more efficiently, but I don't own the datasources I am working from and contextually I am a bit lost when it comes to defining the context for the measure I want to see.  
  • In the new visual calculation, I see exactly what I want to see (albeit without conditional formatting yet!).  If I could understand the context around what is happening to get to those numbers, or better yet, a "suggested measure" I could use that measure as an example measure to populate other visuals.

I am a bit of a novice, but I imagine more and more of your users are in a similar boat converting from Excel and trying to contextualize their visuals.  Regardless, this new feature is helpful!

have you tried using the Performance Analyzer ? this could be an additional feature that breaks down the visual calculation elements as well as the underlying dax.  

ok, thanks for clarifying. We are thinking about how allow you to "promote" your visual calculation to a model measure, so hopefully that will cover what you are after.

BigRob
Frequent Visitor

looks like it will be a great feature and would make a lot of my reports much simpler but is there any plan to release it for the on premise report server version ?  

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.