Forum Discussion

NhiLe297's avatar
NhiLe297
Frequent Visitor
5 years ago

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...
Need Help
doremon2111's avatar
doremon2111
Regular Visitor
5 years ago

The 1st main point of your problem is that you need to restructure your source data table. 

Here is one of my example of table InvoiceLine.

What should be noticed:

  1. Each line is corresponding to 1 lineitem.
  2. I added 4 columns: Job No, Invoice No, Original Studio, Cross Studio. You have to create two separate columns: one for Original Studio, and one for Cross Studio. 
  3. Create a table Studio --> Create Relationship between Original Studio Key vs. Job Code (in table Studio)

With this, you can solve your 1st issue. 

 

The 2nd main point is that your out put table is being incorrectly showed. Power BI isn't like excel, you cannot visualize the table like this. 

You cannot show the total amount of invoice in the same line with ItemLine. It doesnt make sense. 

Here is what i created with Source Data table above