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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
HaiVN
Helper I
Helper I

Filter to show number >= 5

Hello,
I have a matrix table . I do not want to show the numbers  i cells which is < 5. I have tried to set the filter for this table to smaller than 5 but it applies to the sum of each row/ column, or not each cell. How can i fix this problem. Thank you!

HaiVN_0-1715766187881.png

 

1 ACCEPTED SOLUTION
Oscar
Frequent Visitor

Hi, I think you could use a measure to calculate the values, and add an IF statement to return BLANK() in case the value is < 5.

View solution in original post

2 REPLIES 2
HaiVN
Helper I
Helper I

@Oscar Thank you ! It works well!

Oscar
Frequent Visitor

Hi, I think you could use a measure to calculate the values, and add an IF statement to return BLANK() in case the value is < 5.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.