Is it possible to create the table as shown in fig 1 with power bi, If possible please tell me how to do that?
As in the figure, there is a custom header section for account no., and there is subtotal, and at the end there is a grand total.
Go to Solution.
After my research , I'm afraid it couldn't create customized table in Power BI for now.
But you may try to use drill down function in matrix:
drag the fields like this
then expand all down the visual
If not your case, you could post your new idea in Power BI ideas and make this feature coming sooner .
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!