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?
