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
Niharika24
Frequent Visitor

if count (#) is less than 5 then row values should be shown as "Other Factors"

powerbi doubt-27 jan.PNGi have the matrix table , i want that if count (#) is less than 5 then row values should be shown as "Other Factors"

else the original value (row headers)

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Niharika24 ,

Do you want to show the areas marked in red in the image below as "Other Factors"? 

yingyinr_1-1643780500423.png

If so, the field or calculated column that was previously applied to the Values field options will become a Text type. You can create or update your calculated column as follows.

Measure=if(count(#)<5, "Other Factors",count(#))

yingyinr_0-1643780377276.png

In order to be able to provide you with a suitable solution, could you share some sample data(exclude sensitive data) of these fields applied to the matrix? If the calculated column is applied on the Values options of the matrix, please share the formula for the calculated column as well.

Would you consider using conditional formatting feature? For example, if count (#) < 5, use red for the background color and keep the original background color for the rest.

yingyinr_2-1643780881993.png

yingyinr_3-1643780907275.png

Best Regards

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @Niharika24 ,

Do you want to show the areas marked in red in the image below as "Other Factors"? 

yingyinr_1-1643780500423.png

If so, the field or calculated column that was previously applied to the Values field options will become a Text type. You can create or update your calculated column as follows.

Measure=if(count(#)<5, "Other Factors",count(#))

yingyinr_0-1643780377276.png

In order to be able to provide you with a suitable solution, could you share some sample data(exclude sensitive data) of these fields applied to the matrix? If the calculated column is applied on the Values options of the matrix, please share the formula for the calculated column as well.

Would you consider using conditional formatting feature? For example, if count (#) < 5, use red for the background color and keep the original background color for the rest.

yingyinr_2-1643780881993.png

yingyinr_3-1643780907275.png

Best Regards

amitchandak
Super User
Super User

@Niharika24 , if count # is a measure example count(Table[Column])

 

then a new measure

if([count #] < 5, Other Factors", [count #] &"")

 

Ir will make it text , use format function to format count#, if needed

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

Please help

i have atatched the screenshot , kindly if you can help me with details to be taken for measure

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