Forum Discussion
Solved
Top 5 non conformities with text data
Hey guys, I'm starting with Power Bi and I'm learning and enjoying it a lot, but I don't know all the possibilities of this tool. For work purpose I need to do a report about the non conformities i...
Hi BenCha ,
(1) Select the 34 problem columns in Power query and click on Unpivot Columns.->Then add a conditional column.->Click on "close and apply"
(2) We can create measures.
Count_Non = COUNTROWS(FILTER('Table', 'Table'[Custom]="Non Conforme"))Rank = RANKX(SUMMARIZE(ALLSELECTED('Table'),[N°],"count",[Count_Non]),[Count_Non],[Count_Non],DESC,Dense)Flag = IF([Rank]<=5,1,0)(3) Place [Flag=1] on the visual object.
If I have misunderstood you, please clarify in a follow up reply with an example of your expected output.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AnkitKukreja
Super User
Super UserHi! BenCha
Do you have ranking against this data? If not then add additional column in Power query, index should work or if you have any order that you need, use conditional column. Then in table view use sort option and choose sort by your (number column).