https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Box-and-Whisker-visual/m-p/5274113#M13216 <P>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 &nbsp;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!</P> Mon, 06 Jul 2026 14:00:09 GMT sfarooq3 2026-07-06T14:00:09Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Box-and-Whisker-visual/m-p/5274113#M13216 <P>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 &nbsp;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!</P> Mon, 06 Jul 2026 14:00:09 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Box-and-Whisker-visual/m-p/5274113#M13216 sfarooq3 2026-07-06T14:00:09Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Box-and-Whisker-visual/m-p/5337666#M13240 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="934981" data-lia-user-login="sfarooq3" class="lia-mention lia-mention-user">sfarooq3</a>&nbsp;Hi!</P> <P>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.</P> <P>A possible workaround is to create a disconnected faculty table:</P> <P>Faculty Selector =</P> <P>DISTINCT ( Faculty[Faculty Name] )</P> <P>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.</P> <P>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.</P> <P>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.</P> <P>&nbsp;</P> <P>BBF</P> <DIV style="font-family: Segoe UI, sans-serif; font-size: 14px; line-height: 1.2;"><BR /><span class="lia-unicode-emoji" title=":light_bulb:">💡</span> <STRONG>Did I answer your question?</STRONG> Mark my post as a solution! <BR /><BR /><span class="lia-unicode-emoji" title=":thumbs_up:">👍</span> Kudos are appreciated <BR /><BR /><STRONG><span class="lia-unicode-emoji" title=":fire:">🔥</span> Proud to be a Super User!</STRONG> <BR /><BR /><img /> </DIV> Mon, 03 Aug 2026 13:12:53 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Box-and-Whisker-visual/m-p/5337666#M13240 BeaBF 2026-08-03T13:12:53Z