The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
i 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)
Solved! Go to Solution.
Hi @Niharika24 ,
Do you want to show the areas marked in red in the image below as "Other Factors"?
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(#))
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.
Best Regards
Hi @Niharika24 ,
Do you want to show the areas marked in red in the image below as "Other Factors"?
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(#))
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.
Best Regards
@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