Forum Discussion
Conditional formatting issue with matrix visual
ERing then add both dimensions to the ALLSELECTED, review the results now, image attahced.
25Percentile = PERCENTILEX.INC(ALLSELECTED('Table'[Score Subcategory],'Table'[Score Category]),
'Table'[Delta],.25)Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!
ERing Review the attached pbix file and screenshot.
Use All('Table') Instead of any specific column.
25Percentile = PERCENTILEX.INC(ALL('Table'), 'Table'[Delta],.25)Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
fahadqadir3 Thanks for your suggestion, however it does not work with my real data.
Using just 'Table' in the ALL function produces the inccorect value for the 25th percentile.
I think the issue has something to do with row context of the conditional formatting.
The correct 25th percentile value is -36.91, so with my [Color Formatting] measure, anything below -36.91 should be red, but you can see it includes other values as well.
I've included a Sample File here if you would be able to take a look and make a reccomendation.
SAMPLE FILE25Percentile = PERCENTILEX.INC(ALL('Table'[Score Subcategory]),'Table'[Delta],.25) Color Formatting = if('Table'[Delta]<='Table'[25Percentile],"Coral","LightGray")ERing then add both dimensions to the ALLSELECTED, review the results now, image attahced.
25Percentile = PERCENTILEX.INC(ALLSELECTED('Table'[Score Subcategory],'Table'[Score Category]),
'Table'[Delta],.25)Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!fahadqadir3 Thanks very much! I think this works.
One small thing I noticed is that the 25th Percentile result is slightly different when calculated from my actual data table (Table) compared to when calculated from only the numbers present in the Matrix visual.
I wanted to test the accuracy of the 25PercentileCorrect measure so I created a Test table where I input the list of Delta numbers from the matrix visual. I then created the 25PercentileTest.
The 25PercentileCorrect = PERCENTILEX.INC(ALLSELECTED('Table' [Score Category], 'Table' [Score Subcategory]),'Table [Delta], .25) produces a result of -7.29.The 25PercentileTest measure which is PERCENTILE.INC('Test'[Scores],.25). produces a result of -7.30.
I know it an insignificant difference, but I can't figure out what would cause the measures to produce a slightly different result.
Any ideas what would cause this?
