Visual Calculations - Improvements to doing calculations in Power BI
For the last 2 years, the Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it of we told you there is an easy way to get complex calculations done quickly? In this session, we will talk about this exciting development. Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: English300 - Understanding visual calculations in Power BI by Alberto Ferrari
Visual calculations are a new 2024 feature in Power BI, aiming at making it simpler for users to develop calculations at the visual level. Visual calculations are implemented through a new set of DAX functions and the VISUAL SHAPE clause in DAX queries. In this session we introduce the feature and then we quickly go down to discover how it is implemented, when to use it and what not to expect from the feature, so to make educated choices about when to use it or not. TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time): 5:45pm Teams Meeting opens 6:00pm-6:05pm Welcome 6:05pm-7:05pm Feature Presentation 7:05pm-7:10pm Wrap-up REGISTRATION: This is a hybrid event. For in-person, visit the Microsoft Gastown office at 155 Water Street, Vancouver. JOINING THE EVENT: Attendees can join the Teams Meeting starting at 5:45 pm PST on the day of the event. The event will begin at 6:00 pm PST. Please ensure you are on mute to minimize background noise and distractions. During the presentation, type your questions and comments into the chat area, which will be monitored by the event hosts. There will be a Q&A session at the end, where you can unmute your mic and share your video to ask questions.Johannesburg Fabric / Power BI User Group Meeting
Join us for another exciting and learning-filled user group event, on 26 June 2025, starting at 17h00. This month is an online-only event. The agenda for this event is as follows: BI News – JP Louw Fabric News - Cailin Perrie BI Flash: Visual Calculations in Power BI - Sven Vosse Working with Snowflake Schema Calculations - Daryll Groenewald For more details, please use this link: https://www.meetup.com/biug-sa/events/308487610/?eventOrigin=group_upcoming_events
Visual calculations on PowerBI Report Server
Hello, I have a report with 2 tables. The 2nd table contains visual calculation (I'm computing a % delta with previous line ( ([qty] - (PREVIOUS([qty]))) / PREVIOUS([qty]))*100 and in PowerBI Desktop all works as expected. I've tried to load it on my Power BI Report Server, but there only the 1st table loads correctly. The 2nd fails with following error message : The query contains unsupported visual calculation expressions. Either the model capabilities do not support visual calculations or the visual calculation feature switch is off. PowerBI Desktop : 2.138.1452.0 64-bit (novembre 2024) PowerBI Report Server : Version1.22.9153.7886(Janvier 2025) Any idea on this issue? Thank you
Visual Calculation using FIRST()
Hi Folks, I have data for some suppliers and prices for a material: Supplier Date NetPrice SUP1 28.02.2024 20,66 SUP1 29.02.2024 20,66 SUP2 01.03.2024 16,95 SUP2 02.03.2024 16,95 SUP2 03.03.2024 16,95 SUP2 04.03.2024 16,95 SUP2 05.03.2024 19 SUP2 06.03.2024 19 I want to show where the price was going up or down per supplier. The user wants to see this in an indexed line chart something like this: you can see that also the supplier changed so it is basically calculated Calculation = [Average of NetPrice] / FIRST([Average of NetPrice]) But when I do this in a visual calculation it doesn't work. Apperantly FIRST() does not respect the legend (even with the parameters for sorting blank values last). So it takes the first date of all suppliers. but for my second supplier the first value is then blank. this is why i get infinity values Any ideas on that?
