Hi Everyone ,
I have a problem. I create two table chart ,
One table chart show customer information and " Number Of Transaction " of Customer .
One table chart show transaction information
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.
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...
Hi , "Number Of Transaction" is measure , and I mean " chart table "
could you share the pbix file?
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.
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 follow solution https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=c78f7a0c-...
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.
I created post "Show data table chart" https://community.powerbi.com/t5/Desktop/Show-in-Table-Chart/m-p/688609#M331964
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.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!