Forum Discussion
Difference between Power BI Desktop and Power BI Service
Hi GerasimosPan ,
I create a table and make a simple measure, use the measure in the line chart.
Then I publish it to Power BI.
It seems I can see the same visual both in desktop and service.
I think the problem you face may cause by your DAX code. You can use DAX Studio with the service dataset as an XMLA endpoint to check this. Please check this topic for a further study: Solved: Measure works in Power BI Desktop but not after pu... - Microsoft Fabric Community
If it does not help you, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
How to Get Your Question Answered Quickly
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 ,
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?
