Forum Discussion
[ Show in Table Chart ]
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
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!
"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.
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.
Hi ,
This link is file PowerBI , Could you download and see for help me ?
https://drive.google.com/file/d/1EmgXrCQEA8k4u70NamLesprFjIXENs72/view?usp=sharing
