Forum Discussion
Helper II[ Show in Table Chart ]
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.
phamtrinh96It 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
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
"Number Of Customer" is measure , so It don't use filter slicer and I mean this solution is not good.
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.