Forum Discussion
Issue Multi-studios data filter in Power Bi Desktop
Hi Everyone, I am new to Power Bi and has been trying to created a report showing cross studio sales for my company. The data exported from Xero. Within an invoice, there is Job Number with stu...
First thing you want to do is improve the sructure of your source data. You should not have "blank lines with data". If the job number is the same throughout an invoice then you need to add the job number as a field to the invoice details.
Thank you for your feedback.
At the moment the blank lines do not create any issues and I have managed to make the visualisation of the report not showing the blank lines.
Do you have any recommendation on how to fix the studio filtering issues. Main goal is to show correct total cross studio sales for each studio.
Thank you!
