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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
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

4 REPLIES 4
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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

Please help

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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