Filtering a Table Visual

[Mrafih]

I have a table in my power BI report that has the column "Name". Under this column there are two names, Brent and WTI. I want to break it up into two seperate tables, one that just has WTI and one just for Brent. 

Thanks!

[AbhinavJoshi · Accepted solution]

Create two table visual for each desire set one for WTI and One for BRENT. When you create the table, add "Name" into the filters on this visual, do the same for second table visual. In the first table filter by WTI, and on the second one filter by Brent. Hope it helps! 

[rubayatyasmin]

HI, @Mrafih 

1. Duplicate the source table. 

2. In the source table filter the value for WTI and then rename it. Do the same for duplicated table. Filter the name value for Bent. rename it.