Forum Discussion
Using DAX from Power BI in Paginated Report
Hi,
I hope someone can help. I have a report in Power BI that I have then used the DAX from a visual and have used it as a Dataset in Report Builder.
I have the following columns:
Product Name
Number of orders
Average product Unit Price
Total Sale value
It also includes the Grand Total value that automatically gets generated in Power BI. However, I have issues positioning it. As it always appears at the top of the table and is blank, connected tho the Product Name. Does anyone know how to resolve this?
Thanks,
Greg.
3 Replies
- grega
Helper II
Maybe I should remove the totals and create them in Report Builder?
- AnonymousNot applicable
Hi grega,
Perhaps you can take a look at the following link about using Dax expression in paginated report if it helps with your requirement:
Tips and tricks with DAX table functions in paginated reports - Simple Talk (red-gate.com)
Regards,Xiaoxin Sheng
- grega
Helper II
Thanks. Will take a look.