Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I connect power bi report builder to the power bi service, once i create the dataset and try to run the query, the results it gives me are replicated for each customer name,
but actually the real dataset would be like this, in column a left are summed up in the right column we find the unsummarized data.
The problem is that on power bi desktop the results are correct as you can see, while on report builder it replies the values that are not really correct, how do i fix it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Sorbello ,
Please try to put the column "Customer Names" in Row group and select Sum to the column "Sales".
Refer to: Understanding groups in a paginated report - Microsoft Report Builder | Microsoft Learn
Best regards,
Community Support Team_yanjiang