Forum Discussion
Difference between Power BI Desktop and Power BI Service
Hello Anonymous ,
many thanks for the reply.
Reproducing the issue is a bit tough, because, I am uncertain about what causes it. In my original report I have similar visuals that work perfectly, only two seem to be having this issue.
I uploaded my attempt at an MRE, you can find it here. Please note that, in contrast to my actual file, publishing will not directly produce a broken visual, but it is guaranteed to break if you take a couple of minutes to check and uncheck the filters (some patience might be required on this bit). My report has two pages, the issue should appear on both of them.
I read the topic you suggested, I don't think this applies to our case here. In that topic the OP was getting an error message, this is not the case here. Also, their issue was fixed by reviewing some date column, this isn't applicable here, as you will see, my x-axis is an integer.
Thank you for your patience!
Hi GerasimosPan ,
I opened your .pbix file and I do some researches on the file. The measure you write means that for each ‘Group’, it sums up the ‘Price’ from the start of the data up to the current week, effectively giving you a running total or cumulative sum of ‘Price’ per ‘Group’ per ‘Week’, so there is a hierarchical relationship between them.
Whaterver you change the filter in Desktop or in Service, it will give you different image. I think you need to change the Desktop and Service by the same way.
When I uncheck all the filters all together, I check them one by one in Desktop and Service and it shows the same image.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
This is very interesting. I haven't been able to reproduce this in Power BI Desktop. If there is a sequence of moves that achieves this, could you please share? I tried unchecking all the filters then checking one by one (2021, 2022, 1, 2, 3, 4 - to reach your screenshot state), but the measure seems to be working in Power BI Desktop.
On a different note, do you think there is something wrong with the measure? The idea is indeed to calculate the running sum. If there is a way to calculate it that doesn't break, could you please share?
Hi GerasimosPan ,
You start by unchecking all the options, but you have to make sure that the steps for Desktop and Service remain the same, and you can check the same Filter at the same time so that you can make sure the images are consistent.
If you change the Measure, I don't think it's necessary because that's the internal structure, if you change the Measure, it's still dynamic, so it doesn't need to be changed.Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous,
I tried unchecking all the filters, then gradually adding them, but I couldn't replicate it. I also tried to spam-click on filters, but it also didn't work for me.
In any case, I think that when the graph breaks, that means that the measure is calculated incorrectly, since it is supposed to calculate a running total.
If you can replicate it on Power BI Desktop, maybe this means that this isn't a "Desktop vs Service" issue, as this post has implied, but a Power BI Issue. If you can replicate it in Power BI Desktop but I can't, maybe this narrows it down to some version update?
If this is indeed a Power BI issue, that means that either the DAX code calculating the measure is wrong, or that Power BI (Desktop or not) fails to execute the code correctly, depending on the order filters are applied (which 100% shouldn't be happening).
Do you think the code is correct? If yes, could you please help me generate a more reliable MRE, so we can open a ticket about incorrect measure calculation?
Looking forward to hearing your thoughts on this.