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, get a free DP-600 exam voucher to use by the end of 2024. Register 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!

183 REPLIES 183
Kofod
New Member

Hi...

 

Feature: Sorting usings "Visual Calculation" Measures

 

I was messing around with visual calculations, considering where it would be really usefull, then I thought that sorting columns like "ABS([mymeasure])" calculations would be a nice usecase for visual calculations. However, it is not available as a sorting column. 

I think you should consider adding this feature.

 

EDIT:

Just realised that it is because I hide the "visual calculation" - if I unhide, I get access to the sorting VC. I think it should be sortable when it is hidden as well. (it does not work to sort and then hide).

 

regards

so if you hide you cannot sort. the reason is because it would be hard for a viewer to understand how the visual is sorted if it's sorted by something they can't see. What would you prefer here?

In many cases I would agree, and that would be a consideration while designing a visual.

 

However, that many cases sorting could be relevant on something you do not want to show. I might want to sort by the variance actuals vs Budget, while showing the actual numbers as columns in a chart. In this cases the variance I want to sort by could even be the absolute version, i.e. the biggest variances positive and negativ alike, while I'm not interested in showing the absolute numbers in the chart. So being able to hide these is very relevant. Currently the workaround I use is to have the ABS variance in the tooltip, while I actually do not want it there either.

 

Hope this makes sense 🙂

that makes sense, thanks for explaining. How would you envision your viewers to understand that though? Would you not tell them? Let them figure it out on their own? Show some kind of message / indicator that the visual they are looking at is sorted by something they can't see? Alternatives?

Well, I would use many of the same features I would use already when a measure or visual or page needs some extra explaination, like

  • Info functionality mouse over
  • Heading / sub header
  • A transparent picture that can be uhidden using bookmark that utilizes speech bubbles to explain / document functionalities on the page (a very versatile option)
  • Education of users / documentation (in many instances the sorting comes from a requirement in the first place)
  • Sometimes it is logical to the specific users, needing no explaination
  • other

As I see it there are many options to achieve knowledge / understanding on the users part. And we need to remember that the user can change the sorting as well, and this could also be one of the options available to them.

MukeshHDesai
Regular Visitor

Please add new template for Running Total with Reset in the new visual calcuations. It's a way for better user experiences. Thanks for making them happen.

 

thank you that is a great idea!

It would be nice if we could define the templates ourselves as users 🙂

interesting - what would that look like to you then? Would you define the templates for yourself? Share with your team? With your organization? Publicly?

Sorry for late answer... 

My idea was to save know-how to reuse in other visuals and the scope I meaning is our company 🙂

But I think, that the shareing between other users via GITHUB / Community WEB etc. will be used 🙂 

thank you very much for clarifying that, you're input is really appreciated!

OsmarNunes
New Member

Good afternoon, I need help enabling the new power bi tool, visual calculations. 
The OK button to activate the visual calculation does not activate, I have already uninstalled power bi and installed it again,
I have disabled the antivirus and I was unable to do so. Help me please.
My name is Osmar Nunes,
I'm from Brazil/Manaus/Amazonas

I have the same problem, but it seems to be that the whole 'Options' dialog is not functioning. 

I am sorry to hear you are having issues. Can you share a screenshot of what you're seeing and also a screenshot of the about box in Power BI Desktop?

hello Osmar,

 

were you able to find visual calculations in the list of preview features in the options and setting dialog? If you enable visual calculations there the OK button should be enabled. If not, can you please send a screenshot of the options and settings dialog on the preview features page as well as of the about box of your Power BI Desktop?

AlLangstaff
Frequent Visitor

Really nice addition. Main annoyance right now is the lack of Line and Column combination chart so I can create a dynamic axis Pareto with both the Column and Cumulative Percentage. Doesn't officially seem to be on excluded Visuals, but it's not selectable.

you are right, I will add it to the list of limitations. thank you.

Rogwe
Frequent Visitor

Hi!

 

A very nice feature!

But in the swedish version it seems to be missing.

I have ticked the box in the preview for the new function and restarted the computer and program multiple times the last days.

But it's nowhere to be found.

Is something missing in this swedish version?

 

oh no! I am so sorry to hear that. I am not aware of anything that might have caused this. Can you please share a screenshot of your preview features list as well as the about box from Desktop so we can investigate? You shouldn't have to restart your computer, just Power BI Desktop after enabling the feature.

Hi,

maybe it is similar to the issue I am experiencing.
I am not able to see the new feature in the ribbon, but with a right click on a visual I can create a "new calculation".

BS123456789_0-1709189730400.png

BS123456789_1-1709189780598.pngBS123456789_2-1709189825850.png

 

it's not on the modeling tab, as it's not a modeling feature.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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