Forum Discussion
[ Show in Table Chart ]
Hi phamtrinh96 ,
You can create column NumberOfTransaction_Column, and put it in Slicer visual as new slicer. It seems your Hierarchyslicer NumberOfTransaction have no logical relationship with the other tables, and the measure can't be put into slicer visual, so I recommend you create column as new slicer.
NumberOfTransaction_Column = CALCULATE(COUNT(TransactionInformation[RestaurantCode]),FILTER(ALLSELECTED(TransactionInformation),TransactionInformation[CustomerNumber]=EARLIER(CustomerInformation[CustomerNumber])))
When make some selections in the new slicer, return result showing picture below.
For your demand in original page >>And I want show The Customers have " Number Of Transaction " > 1, you can put the column NumberOfTransaction_Column into the Visual Level Filter of table chart which show transaction information , setting it as "is greater than 1", don't forget click the "Apply filter" button.
Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EdomtDbYD8VBn2KBskhxPBIBO5cx5qJvjDoaVbdpnRIwQw?e=Oye9c6
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ,
Thanks for your help.
Why do I use measure instead of column?
That's because if I have a trading time slicer. I select a time period that will display its transactions during that time and "Number Of Transaction" corresponding to the time period. That's why I use measure. So if you have more options for trading time, your solution is not good, do you have any other solution for me?
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.
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?
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
No , I'm sorry , But it is impossible. If you want to help me , then Pls send me file powerbi your. Thanks you
Hi phamtrinh96 ,
Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EdomtDbYD8VBn2KBskhxPBIBO5cx5qJvjDoaVbdpnRIwQw?e=IxN3Jv
Best Regards,
Amy
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