Forum Discussion
jeroenterheerdt
Microsoft Employee
Microsoft EmployeeShare 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 ab...
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.