Forum Discussion

phamtrinh96's avatar
phamtrinh96
Icon for Helper II rankHelper 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 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

Need Help

30 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      phamtrinh96
      Icon for Helper II rankHelper II
      7 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        could you share the pbix file?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Are the data sets from different tables?

     

    if they are all from one source, you should be able to drag your "Number of transaction" measure to the visual level filter and select > 1. dont forget to click the "apply filter" button as well.

     

     

    • phamtrinh96's avatar
      phamtrinh96
      Icon for Helper II rankHelper II
      7 years ago

      It is from 2 different data tables.

      I use filter in chart table first , But It does not change the second chart data after using the 1st chart filter

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Ok. what you can do (im not sure if this will work) is:

        1.) in the second table, put customer number again as another value. 

        2.) select this value and select it to display count.

        3.) now this count value should also appear in the filter box, then just select >1.

        4.) Once you´ve applied the filter, you can remove the value from step #1.

         

        you dont have to put the transaction measure in the second table as a filter with this method.

         

        i hope it works!

         

         

    • phamtrinh96's avatar
      phamtrinh96
      Icon for Helper II rankHelper II
      7 years ago

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

      And I thing this problem is not easy , But we often encounter this problem because the powerbi does not support the filter in Measure.

      • rocky09's avatar
        rocky09
        Icon for Solution Sage rankSolution Sage
        7 years ago
        can you provide an example :
        Suppose, if you select number 2 from the slicer, what are the results you want to see in the Table 1 and Table 2?