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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
314mp_M0th4
Resolver I
Resolver I

Filtering matrix columns with dropdown

Hello, this is not as simple as it sounds. Lets say I have data :

TypeValue
a5
a20
b15
b10
c15
c30

And I want a matrix like this :

Type 1Type 2
valuevalue
valuevalue

Where the types columns are linked to a dropdown where you can select a, b or c.

Is this possible?

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

Hi @314mp_M0th4 ,

 

If you want to create a matrix visual that do not aggregate your data, you need to add an column for row field:

vjianbolimsft_0-1689749485217.png

vjianbolimsft_1-1689749497244.png

Output:

vjianbolimsft_2-1689749515483.png

vjianbolimsft_3-1689749530668.png

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-jianboli-msft
Community Support
Community Support

Hi @314mp_M0th4 ,

 

If you want to create a matrix visual that do not aggregate your data, you need to add an column for row field:

vjianbolimsft_0-1689749485217.png

vjianbolimsft_1-1689749497244.png

Output:

vjianbolimsft_2-1689749515483.png

vjianbolimsft_3-1689749530668.png

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks! I also found that I am a dummy and by using basic filtering on page from the filtering pane you get the same result as using a dropdown.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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