Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
The measure below is a filter to remove all zero values in my matrix, but since I am using the Financial Reporting Matrix by Profitbase I need to remove one row value from the filter. Any suggestions as to how I can apply these conditions on 'table.value <> something'?
@Petsnell you can use <>
example
IF([Measure 1]=0 && [Measure 2]=0 && [Measure 3]=0 && [Measure 4]<> 0,0,1)
also you can use && in place of AND(
IF([Measure 1]=0 && [Measure 2]=0 && [Measure 3]=0 && [Measure 4]=0,0,1)
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak Thank you for answering so quickly. Please apologize my terrible example below, I will add on this if necessary.
In short, I want to remove row values that equal zero in the measures listed above except for the second last row in the picture, let's call it 'table.example' with value = F.
@Petsnell , removing a row while creating a measure(means table row) is much different from removing a row(visual table) where a measure is 0 or blank.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
In short, I want to see R&D, but hide operations and other rows where all columns might be 0.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
11 | |
10 | |
9 | |
8 |