First look at visual calculations in Power BI!

Рет қаралды 4,845

4 ай бұрын

Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @ruthpozuelo@techhub.social
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Пікірлер: 30

@didiermaignan76400 3 ай бұрын

Excellent ! Ruth, you made visual calculation christal clear. This is also in Service this month, and this is very tricky to use especially in non US language.

@SergiyVakshul 4 ай бұрын

To edit a calculation formula just click on a calculation representation in Values well, then “Edit calculation”. For me the main profit from this feature is the ability to hide columns, which was impossible to do before.

@antonysamarawickrema3886 24 күн бұрын

You can edit the visual calc in the formula bar. First click on the visual calc which will be on the lower right side of your power bi. Then put your cursor on the visual calc and edit

@bradj229 4 ай бұрын

Thanks for this video Ruth. I prefer your videos over others for many reasons, including making short to the point videos (this one) and longer (DAX fridays) when needed, vs one 30min+ video that you have to sit through because there's no context around what's covered. Thanks again :)

@CurbalEN 4 ай бұрын

Thanks! :)

@bharathharthikote9168 4 ай бұрын

So helpful to me right now

@dutchdatadude 4 ай бұрын

Thanks for sharing! We are just starting on this journey, loads will be improved over the comings weeks and months. Rows is not in scope though.

@soy_leche 4 ай бұрын

Thankful for closed captioning

@martinbubenheimer6289 4 ай бұрын

For me the use case would be self-service BI if you need a calculation but cannot change the semantic model. Otherwise, the lack of reusability makes it a governance and consistency nightmare. But the hide column feature itselfs is a nice addition if you can also use it without visual calculation and still sort by a hidden column.

@CurbalEN 4 ай бұрын

True! That is neat indeed :)

@thomasivarsson1291 4 ай бұрын

Tack Ruth!

@ravigangasani7682 2 ай бұрын

What if we have field parameters in visual, Can we use visual calculations if yes please let me know

@lonyo5377 4 ай бұрын

Can you add a "calculation" which is a text content/note/explanation against a line?

@CurbalEN 4 ай бұрын

Not sure, but you can do that with normal DAX

@ramiro6164 4 ай бұрын

Interesting 🤔

@visheshjjain 4 ай бұрын

Does the feature work in the service?

@CurbalEN 4 ай бұрын

I should, have you tried?

@visheshjjain 4 ай бұрын

@@CurbalEN I tried editing the report in the service but there doesn't seem to be an option to create such calcs in the service. I also got a warning message saying "This visual contains a visual calculation which can't be edited. Changing the fields on this visual may break the calculation." We can't format the calculation either, in regards to decimals etc.

@CurbalEN 4 ай бұрын

@visheshjjain Sorry I misread your comment. I dont think you can create visual calcs on the service just view them

@dutchdatadude 4 ай бұрын

You can't yet, but will be able to create and edit visual calculations very soon.

@bharathharthikote9168 4 ай бұрын

Its not showing in my desktop, How to get this feature Please reply 😅

@dutchdatadude 4 ай бұрын

Enable it in your preview features

@bharathharthikote9168 4 ай бұрын

@@dutchdatadude thanks I will try it

@alicedwonderland7733 4 ай бұрын

Looks like a lot of work, the new calculation. I would not use it. Thanks for the info, Ruth!

@CurbalEN 4 ай бұрын

It is useful in certain scenarios like building financial statements (if they develop it further). Keep an eye on it!!

@alicedwonderland7733 4 ай бұрын

@@CurbalEN But I'll have a need of this formula in several visuals and even reports, and that's not even counting the fact you can't change it. But I'll keep an eye on your channel to see any possible improvements :)