Forum Discussion
Microsoft EmployeeShare your thoughts on visual calculations (preview)
Really appreciate this option. Smashing the like-button. Two items that would be super helpful:
- Conditional Formatting (looks like you are already tracking that)
- A way to view the underlying low-level functions so it makes it easy to add to the model. I have a difficult time contextualizing the context in which I want to view things - being able to create a visual using these simple ones would go a long way to helping me execute more efficiently.
Thanks again - I appreciated your YouTube video!
Microsoft Employeethank you - can you elaborate a little bit more on the second point maybe? Am I correct in understanding you'd like to see a way for you to see the window function (such as window/offset/index) you'd invoke if you'd wrote the visual calculation as a measure?
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!
- jeroenterheerdt
ok, thanks for clarifying. We are thinking about how allow you to "promote" your visual calculation to a model measure, so hopefully that will cover what you are after.
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.
