cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Resolver I

## Filter 0 from One Matrix Column Only

Hey,

I have a Matrix table with Values which appear in 3 categories (Table example below):

 Category Value A 10 A 0 B 0 C 0 B 30 C 20

When displaying this data in a Matrix with Columns as Category and Values as Value it can be seen below. What I would like however, is the Matrix to filter out the 0's that appear BUT only if Category C has a 0 and not if A or B has a 0.  I guess I need some sort of measure to sort this as Advanced Filtering does not work (as filtering 0 removes all instances of 0 from values).

 A B C Row 1 10 30 0 Row 2 0 0 20
1 ACCEPTED SOLUTION
Super User

Add it to the visual filters and set the value to 1.

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

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

4 REPLIES 4
Super User

@TotunG , you can use this measure for filtering:

``Measure = IF(SELECTEDVALUE(Table[Category]) = "C" && SELECTEDVALUE(Table[Value]) = 0, 0, 1)``

Set it equal to 1 in the matrix visual filters.

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

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

Resolver I

Nice - thank you. I get this can be used as a sort of indicator now. But I'm still struggling to get this to filter out Category C 0 values only? Do you know the next steps to this?

Super User

Add it to the visual filters and set the value to 1.

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

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

Resolver I

Appreciate the help, although it still doesn't work. I'll give you kudos tho.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors