Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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!
I have the option checked, have restarted but "new calculation" is not visible.
it's on the Home ribbon, not on Modeling.
Hi
If i have understood the documentation correctly (*) when visual caldulations are used, it is no more possible to create a public web link.
While i understand the need to make some features payable, i do not think this is the best way, except if this is for technical reasons, but then it should be explained.
I think this should be adressed via the current licencing mechanism (for instance force the developper to use a premium per user licence) etc, but not by restricting access which is counter productive for all parties.
(*)
currently publish to web is blocked because of a technical issue. It's not licensing driven.
Will this be solved? If yes when?
I published to web a dashboard that uses a visual calculation and the table that contains it is not visible. It has the following error:
it will be resolved - it's on the documented list of limitations.
I need to format that new calculation. make it currency. I'm not seeing how to do that.
thanks
while FORMAT works, it changes the output to text so you can't use it for further calculations. We will add support for formatting soon.
Use FORMAT as the output of the calculation.
The only issue with this is that FORMAT returns a text value, which means that if you want to do something like add data bars to the column as a cell element, nothing happens. Which is to say, we need to be able to do more than just format the data in the column; we need to be able to control its data type as well.
agreed - that is coming.
Use case for using visual calculations as basis for conditional formatting: Highlighting value changes
Can't select the calculation.
would be nice to be able to, though.
yes, conditional formatting is on the documented list of limitations.
Agreed - conditional formatting is on the list of limitations.
Hi @jeroenterheerdt,
This is a great step in the right direction. Thank you and the team for making our day jobs easier.
Going ahead, I see huge value in making these functions available in dax generally. Is that in the pipeline?
Hi, if you with "these functions" you mean functions like RUNNINGSUM then the answer is no, not at this time.
That's a real shame. Thank you for your reply.
I found an error / bug, I tested the visual calculation feature on a matrix but removed it when I saw conditional formatting wasn't yet available. However, when my end-users tried to export data from that matrix they recieved an error: "exporting data is disabled because it contains a visual calculation or hidden field." This happening despite the fact that the matrix did not currently contain visual calculations nor hidden fields. I had to rebuild the matrix from scratch and re-publish the report to correct the issue, so it seems like using Visual Calculations infects/contaminates whatever visual you drop them on in a way that lingers after removing the Visual Calculation.
oh no! That is not supposed to happen. I will investigate this.
What are the consideration regarding these new visual calculations and functionality the field parameters introduced a while back. As far as I can see these two features does not integrate currently, and I was wondering if it would be possible to to have these two Power BI features integrate somehow.
In many instances, we use field parameters not only to switch dimensions but also measures on visuals.
When introducing visual calculations, it also introduces the questions, if these could be used dynamically together.
It might be that they are too technically different to have working together, but I just have to raise the question.
field parameters are not supported with visual calculations yet as listed on the limitations.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
89 | |
70 | |
66 |