Forum Discussion

phamtrinh96's avatar
phamtrinh96
Helper II
7 years ago

[ Show in Table Chart ]

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 in...
Need Help
phamtrinh96's avatar
phamtrinh96
Helper II
7 years ago

"Number Of Customer" is measure , so It don't use filter slicer and I mean this solution is not good.

I follow solution https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=c78f7a0c-5fa4-40c9-896a-d161eaa9449e&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer#bmc78f7a0c-5fa4-40c9-896a-d161eaa9449e 

I created slicer filter " Number Of Customer". 

When I chose the number of transactions, only the change in the 1st chart, but there was no change in the 2nd chart according to the 1st chart.

 

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi phamtrinh96 ,

 

You can create measure Filter1 in the first table, and put the Filter1 into the Visual Level Filter of table chart which show transaction information , setting Filter1 as "is not blank", don't forget click the "Apply filter" button.

 

Filter1= IF(MAX(Table1[Number Of Transaction])>1,1,BLANK())

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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

 

      • v-xicai's avatar
        v-xicai
        Community Support
        7 years ago

        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.