Power BI Visual Calculations: Complete Tutorial!!!

[@beingrishi6450]

Excellent Update so far alongwith Dynamic subscription

[@PowerBIBro]

Thank you for all your support!

[@HappywithCath]

Wow, thanks for getting a video out on this so quickly!

[@PowerBIBro]

My pleasure!!

[@unnikrishnansanthosh]

clear-cut explanation, thank you for sharing

[@PowerBIBro]

Thank you!!

[@mjhardee]

Thanks for the walkthrough! Very helpful! I'm slowly learning Power BI and have a quick question: How do I hide calculations or is there a simpler way to get the following to work? I have Vendor in my Rows in the matrix and have Year in my columns. I was able to add a visual calc to do the difference between 2024 and 2023, but it does the calculation twice (once for 2023 which always results in 0 and once for 2024 which gives me what I want). How do I hide that 2023 calc? Unfortunately I can't switch the Rows/Columns around because I could have 50+ vendors at one time, unfortunately. Here's my formula: Diff = [Cases] - FIRST([Cases], COLUMNS) This is what I end up getting and need to hide the first "Diff" column: 2023 2024 Cases Diff Cases Diff Vendor 1 10 0 15 5 Vendor 2 40 0 32 -8 Vendor 3 30 0 35 5 Thanks in advance for the help!

[@PowerBIBro]

Thanks for your support and great question! That’s a tough one, offhand I don’t have a guaranteed solution. Something I’ve done in the past is create conditional formatting which changes the font color to the same color as the background if the value = 0. This would give the appearance the column was empty but still had a space, better than all 0’s though. Let me know what you land on!

[@mjhardee]

@PowerBIBro Thanks for the suggestion! Didn't think about that one, but what I ended up doing was just minimizing the columns until they're almost not visible. It got the job done but wasn't the cleanest, unfortunately. I'll let you know if I find a better solution though. Thanks again for the walkthrough!

[@PowerBIBro]

Love it and thanks for sharing!!

[@PowerBIBro]

@@mjhardee love it and I've done that same process before as well!

[@Rodrigo-j6o7x]

Excellent video!!!!, just subscribed

[@PowerBIBro]

Awesome and thank you!!

[@cheriekeller1769]

Hi, I am trying to figure out how to get the filters across the top as you did in this video. I am very new to powerBI - just trying to make a quick map to add to a project (and I am using a set up very similar to how someone else did it in a similar project. I can't for the life of me find instructions on how to set it up with the filters across the top (and I am trying to minimize how much I bug the person who made the original project. Thanks so much.

[@PowerBIBro]

Thanks for the question and I will be happy to help! I’m 100% certain which part of the video you are referring to, will you provide a timestamp which contains the filters you’re describing? Looking forward to helping!!

[@beingrishi6450]

Great Explanation, cleared the concept

[@PowerBIBro]

Thank you glad it is helpful!

[@rn4341]

Hey, I'm trying that formatting function for my running sum. It works well when doing it on a table visual, but when switching to a line chart, the line on my visual disappears and only comes back when I remove the FORMAT function right before my Runningsum. Any help on this?

[@PowerBIBro]

Thanks for the question! The format function converts the value to a user friendly value, but it removes the numerical properties (which are needed for the line chart). You can also create two calculations, one with the format and another without. Then use the non formatted for the line, and the other for the tooltips etc..

[@rn4341]

@@PowerBIBro it does show as a value on the line chart, ( e.g 620,829.00 or 0.6M) that works fine, But when formatting to currency, the line disappears.

[@PowerBIBro]

@rn4341 what if you try creating a 2nd measure that is formatted as currency, using it only on the tooltip or data label? This way the line will display, but the label and tooltip will have the $ currency format

[@Spotlight.Data.Analytics]

Nice explanation. Thanks!

[@PowerBIBro]

Excellent thank you!!

[@SmartBimson]

Really 🎉cool Video ! Very informative 👍🏻

[@PowerBIBro]

Glad you liked it!

[@creandoyblogueando]

Great presentation!!!

[@PowerBIBro]

Thank you very much!

[@dutchdatadude]

Thanks for sharing, hope you like it!

[@montassarbellahjaaouane8291]

Thanks

[@PowerBIBro]

My pleasure and thanks for your support!!

[@SnkRobertoHz]

Amazing! Excellent video. You just got one subscriptor. More videos with visual content please! Many thanks

[@PowerBIBro]

Awesome and thank you!!!

[@decentmendreams]

It looks like what InfoRiver has been doing .

[@PowerBIBro]

Thanks for sharing, will check it out!