Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
arun3039
Frequent Visitor

How to filter text column using Dax

I want to filter and show data according to the category. which should be filtered in my Table chart

Product_idProduct NameCategory
1aMobile
2bCharger
3cMobile
4dMobile
5eCharger
6fHeadset
7gCharger
8hheadset
9iMobile
10jCharger

I want to display whose category is Headset & Mobile

1 ACCEPTED SOLUTION
v-cazheng-msft
Community Support
Community Support

Hi @arun3039,

 

You may try this solution.

1 Create a measure like this

FilterTable = CALCULATE(MAX('Table'[Category]),'Table'[Category] IN {"Headset","Mobile"})

 

2 Add filters on this visual to show items when the value is not blank

vcazhengmsft_0-1661237637692.png

 

In fact, you could simply use Filters pane to achieve it: just tick the category you need to show but leave other catetories unticked.

 

Attached the pbix file as reference.

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

 

Best Regards,    

Community Support Team _ Caiyun

View solution in original post

3 REPLIES 3
v-cazheng-msft
Community Support
Community Support

Hi @arun3039,

 

You may try this solution.

1 Create a measure like this

FilterTable = CALCULATE(MAX('Table'[Category]),'Table'[Category] IN {"Headset","Mobile"})

 

2 Add filters on this visual to show items when the value is not blank

vcazhengmsft_0-1661237637692.png

 

In fact, you could simply use Filters pane to achieve it: just tick the category you need to show but leave other catetories unticked.

 

Attached the pbix file as reference.

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

 

Best Regards,    

Community Support Team _ Caiyun

arun3039
Frequent Visitor

Thanks Amitchandak, Its displaying count with category, but i want to display filter rows on that table Chart.

amitchandak
Super User
Super User

@arun3039 , Create a measure and use that with product and product if in visual

 

calculate(countrows(Table), filter(Table, Table[Category] in{"Headset","Mobile"}))

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors