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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply

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!

134 REPLIES 134
jbas
Frequent Visitor

First of all, what a great feature! I have been waiting for this, for a long time. Well done!

 

Right now it seems that I am not able to reference any of my measures of the model in my visual calculation.

 

I would like to be able to add a calculation that is only used in the specific visual. 

 

For instance, I have a measure [Turnover] in my model. I have a table that needs to show turnover / 1000 per region. 

Right now I have to add the [Turnover] measure to the table and hide it. Then create a visual calculation: Turnover / 1000.

 

Would be a lot easier, if I could just use the [Turnover] measure in my visual calculation straight away.

Hello and thanks for checking in. What you mention is in fact by design and kind of the point of this feature. You can't refer back to the model because it would bring back the complexities we're trying to "leave outside". Just bringing in the measure easily resolves this as you have discovered.

Thanks for your reply. I totally understand that you are trying to hide the complexity. I actually expected that you would give me the "by design" answer. 😊

 

However, I do feel that it has added value to be able to reference the measure from the model. Perhaps a new function could still hide the complexity, but allow expert users to use measures from the model. This way you don't have to pollute the visual with columns you have to hide.

 

For instance take the following visual calculation : MEASUREFROMMODEL('[Turnover]') / 1000

 

The MEASUREFROMMODEL function allows me to get a measure from the model. This way you still hide the complexity from basic users, but an advance user can get measure from the model.

maybe, but explaining the result of what MEASUREFROMMODEL would return is hard to do, which is the beauty of visual calcs.

TinaM
Regular Visitor

This visual calculation is a very cool feature, but I am not seeing the icon to hide any of the fields in my visual.

hello Tina,

 

thanks for checking in. The icon to hide fields should be shown in the visual calculations edit mode in the "Build a visual pane":

 

jeroenterheerdt_0-1708629946187.png

 

Please let me know if you can't find it there.

Never mind...I did find it.  Sorry, I didn't have it in the edit calculation mode.

great, thanks for letting me know!

Pim_7890
New Member

  1. Geen mogelijkheden om het format van de meting aan te passen.
    Dit moet nu aangepast worden met FORMAT().
  2. Geen mogelijkheid voor voorwaardelijke opmaak van cellen.
    Dus geen mogelijkheid voor bijvoorbeeld een stoplicht-opmaak of iets dergelijks.
  3. Geen mogelijkheid voor berekeningen met meerdere tabellen zoals RELATED().

hello Pim, thanks for your feedback. #1 and #2 are on the list of limitations published here.
#3 is by design. You cannot refer back to the model because you are no longer in the model. This is a core design artefact of visual calculations which makes your life easier (you don't have to worry about what makes DAX so hard because you are no longer in the model). If you want you can easily bring those columns from other tables into the visual, hide them from view so you can refer to them using visual calculations. I hope that helps.

back_to_sql
New Member

Hi! 

would be cool to be able to specify the orderby parameter of the running calculations. I don't think it's currently possible, or?

Other way to solve this would be to always take the sorting of the table. Right now the runningsum() function will sort by the category by default, and when you sort the table by a metric, the running sum doesn't adjust to the new sorting. 

 

Great addition though!

Hello @back_to_sql ,

from the limitations on this feature is the following : 

  • You can't change the sort order for visual calculations.

check the list of limitations https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




CarlosAzabacheS
New Member

It would be interesting to be able to have these calculated fields and with them create the necessary measures from the matrix we generate. Having it only in the control leaves me halfway, for example, how do I calculate the GINI, which is the result of the maximum value of a column from the matrix?

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
Advocate I
Advocate I

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.

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
New Member

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?

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

aomsbansal
Frequent Visitor

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) 
CountrySalesQtySalesQtySalesQty
India4353453434775379
China54564545641090128
USA344334346877
France6645644370688
Germany46454345480508

hello, field parameters are not supported at this time.

What are your thoughts about point 2? 
@jeroenterheerdt 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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