Forum Discussion
4 box model visual
is there any 4 box model visual available in power BI.
I have data of Exam result and faculty feedback. i want to create four box model like visual so that i can calculate
1: which faculty's result is average but feedback is good
2: Which faculty's result is good and feedback is good
3: which faculty's result is average and feedback is average
4: which faculty's result is good and feedback is average
i want to show the name of faculties in the boxes accordingly.
Hi Anonymous ,
You can make your own, by combining four cards with a different measure for each. See my picture below. Click on it to enlarge. Included in it, is the measure for box 1. Just write 3 more measures, one for each box, and change the "Good" or "Average for each one. Please note in my table, I entered some "Poor" as well. I will include a picture of my table, too.
If this solves your issue, please mark this as the solution! Kudos are nice too.
Faculty Box 1 = CALCULATE(CONCATENATEX(Table1,Table1[Faculty], ", "),Table1[Result]="Average",Table1[Feedback]="Good")
1 Reply
Hi Anonymous ,
You can make your own, by combining four cards with a different measure for each. See my picture below. Click on it to enlarge. Included in it, is the measure for box 1. Just write 3 more measures, one for each box, and change the "Good" or "Average for each one. Please note in my table, I entered some "Poor" as well. I will include a picture of my table, too.
If this solves your issue, please mark this as the solution! Kudos are nice too.
Faculty Box 1 = CALCULATE(CONCATENATEX(Table1,Table1[Faculty], ", "),Table1[Result]="Average",Table1[Feedback]="Good")