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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
v-pussah
Microsoft Employee
Microsoft Employee

Filter by multiple column headings

vpussah_0-1634002154435.png

Problem Statement: I have a table with multiple feature Columns. I have to show the aggregated value of those feature column on a line or bar chart. I need one slicer where all these Feature columns get listed and if I select any of the Feature it should show only that value. Basically, it should filter on my slicer.

I created another table with unpivoted columns from the original table and Renamed attribute as Features. Now, I have the list but both the tables are not connected to each other and hence unable to filter. Need help to resolve this issue. I cannot unpivot and use the attribute column in the same original table as it will expand the row count into millions.

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @v-pussah 

 

If you want aggregated results, you can aggregate them in Power Query directly by using Group By feature. 

21101403.jpg

 

After unpivoting, group by Attribute column and get aggregated values in a new column. For example in above image, I calculate Sum for each group member. 

 

Then use this new structured table to create a bar chart. 

21101404.jpg

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @v-pussah 

 

If you want aggregated results, you can aggregate them in Power Query directly by using Group By feature. 

21101403.jpg

 

After unpivoting, group by Attribute column and get aggregated values in a new column. For example in above image, I calculate Sum for each group member. 

 

Then use this new structured table to create a bar chart. 

21101404.jpg

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

amitchandak
Super User
Super User

@v-pussah , when you unpivoted the table to have feature as row, then you can take slicer from that column or you can join the two table.

 

Or create a table 

measure =

var _tab = allselected(Feature[feature])

return

calculate(sum(Table[value]), filter(Table, Table[Feature] in _tab))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak : This will not work. I cannot unpivot in the original table. So created a separate table. Now, how do i join these 2 tables.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors