[ Show in Table Chart ]

[phamtrinh96]

Hi Everyone , 

I have a problem. I create two table chart ,

One table chart show customer information and " Number Of Transaction " of Customer . 

Ex : 

 

One table chart show transaction information 

Ex : 

And I want show The Customers have " Number Of Transaction " > 1 , so I use filter 

The chart " Transaction Information "  still shows all transactions, I just want to display customer transactions with "Number Of Transaction" greater than 1. 

Thanks you

[v-xicai]

Hi @phamtrinh96 ,

You can create many to one relationship between table CustomerInformation and Change like picture below, which will meet tour demand.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[phamtrinh96]

No , With "NumberOfTransaction " It will be different if you choose different time periods. And this is just a small clientele, if we have more than 1 million customers it will not be possible. Why don't you think in the direction of measure?

[v-xicai]

Hi @phamtrinh96 ,

After createing many to one relationship between table CustomerInformation and Change like picture above,  return the result will change corresponding to the time period, you can have a try.

Best Regards,

Amy  Cai

[phamtrinh96]

No , I'm sorry , But it is impossible. If you want to help me , then Pls send me file powerbi your. Thanks you

[v-xicai]

Hi  @phamtrinh96 ,

Does that make sense? 

Best regards

Amy Cai

[phamtrinh96]

Hi , It is Fail , If I choose TransactionDate From 1stMarch To 31stMarch then It show 

It is fail in 2 points. 

- Chart Table first doesn't show data

- After I choose NumberOfTransaction = 2 then Chart Table second doesn't show data. I want result is The Transactions of CustomerNumber = 2 in this case

[v-xicai]

Hi @phamtrinh96 ,

Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EdomtDbYD8VBn2KBsk...

Best Regards,

Amy

[Anonymous]

Hi @phamtrinh96 ,

In the Query editor add Customer Name column to the Transaction Info table, close and apply the changes.

In the Power BI editor, add a measure to show number of transactions.

Later add the same measure to the filter. 

Hope this works for you...

Regards,

Chetan

[phamtrinh96]

Hi , "Number Of Transaction" is measure , and I mean " chart table "

[Anonymous]

could you share the pbix file?