cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phamtrinh96 Regular Visitor
Regular Visitor

[ 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 : 

 Capture.PNG

One table chart show transaction information 

Ex : 

Capture.PNG

And I want show The Customers have " Number Of Transaction " > 1 , so I use filter 

Capture2.PNG

The chart " Transaction Information "  still shows all transactions, I just want to display customer transactions with "Number Of Transaction" greater than 1. 

Thanks you

30 REPLIES 30
chetanamare Regular Visitor
Regular Visitor

Re: [ Show in Table Chart ]

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 Regular Visitor
Regular Visitor

Re: [ Show in Table Chart ]

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

chetanamare Regular Visitor
Regular Visitor

Re: [ Show in Table Chart ]

could you share the pbix file?

Anonymous
Not applicable

Re: [ 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.

 

 

phamtrinh96 Regular Visitor
Regular Visitor

Re: [ 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

Anonymous
Not applicable

Re: [ Show in Table Chart ]

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 Regular Visitor
Regular Visitor

Re: [ Show in Table Chart ]

"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.

 

phamtrinh96 Regular Visitor
Regular Visitor

Show data in table chart

Hi Everybody,

I created post "Show data table chart" https://community.powerbi.com/t5/Desktop/Show-in-Table-Chart/m-p/688609#M331964

Although I received your enthusiastic support, I still haven't solved the problem. So I created a powerBI file so you can help me understand my problem. Please, see the powerbi file and give me an idea.
Thank you
File PowerBI in this link
phamtrinh96 Regular Visitor
Regular Visitor

Re: Show data in table chart

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.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 19 members 766 guests
Please welcome our newest community members: