Forum Discussion
Box and Whisker visual
I want to display faculty metrics within each department (such as number of publications) using the box and whisker diagram. There is a search bar where I can search departments within the organization and the Box and Whisker by MAQ Software visual would update the box diagram. I would to further drill this down by searching and comparing faculty within a department. I cannot do this by simply adding a faculty name slicer as the box and whisker diagram would disappear when any one person is selected on the slicer. I want to compare different faculty members within the same deparmtment. Could this possibly be done using this visual, or is there another visual I can use in Power BI to make similar comparisons? Thanks!
1 Reply
sfarooq3 Hi!
This happens because a box-and-whisker chart needs several faculty values to calculate the median, quartiles, and whiskers. When you select only one faculty member, the slicer filters out everyone else, so there is no longer a distribution to display.
A possible workaround is to create a disconnected faculty table:
Faculty Selector =
DISTINCT ( Faculty[Faculty Name] )
Use this new column in the faculty slicer, but don’t create a relationship with the main model. This way, selecting a faculty member won’t remove the other people from the department’s box plot.
The limitation is that the MAQ visual may not allow you to highlight the selected faculty members as individual points. For that type of comparison, I’d suggest using Deneb. You can keep the department-level box plot and overlay the selected faculty members as highlighted dots, with their names and publication counts in the tooltip.
If you mainly want to compare faculty members directly, a dot plot or ranked bar chart may also be easier to read than a box-and-whisker chart.
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
