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
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:
Thanks and we look forward to hearing your feedback!
great, thanks for letting me know!
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.
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 :
check the list of limitations https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview
Proud to be a Super User! | |
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?
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.
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?
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 |
hello, field parameters are not supported at this time.
you should be able to do this with expand / collapse. Documentation is still being published for those.
Hi @jeroenterheerdt ,
Currently the visual calcualtion documentation links mentioned in your visual calculation and the monthly Power BI blog posts are still unavailable.
Hello @nielsvdc ,
check this https://powerbi.microsoft.com/en-us/blog/visual-calculations-preview/
Proud to be a Super User! | |
I know. But for example the link mentioned in the post for the RUNNINGSUM function is not working.
the docs are still coming online, but I expect those to start working soon.
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)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
109 | |
107 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
95 | |
91 |