Box and Whiskers data visible in a separate table

[Kdriss]

Hi,

How can we display the the data available in the black area in a separate table ?

Thanks

[Anonymous]

A box and whisker plot (sometimes called a boxplot) is a graph that presents information from a five-number summary. In a box and whisker plot: the ends of the box are the upper and lower quartiles, so the box spans the interquartile range. the median is marked by a vertical line inside the box.

[Kdriss]

Thanks lewis

But do you have on ideas on how we could get theses information in one separate table?

[v-alq-msft]

Hi, @Kdriss 

Based on your decription, I created data to reproduce your scenario.

You may create a slicer to filter the visual you want.

Then you need to use the slicer to filter the result, make the visual selected, click 'more option' icon at the top-right corner, choose 'show as a table'.

Finally you will see the corresponding table under the visual.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kdriss]

Hi Allan,

Thanks for the time you took to solve my issue. 

I have tried your solutions but this is not what i amlooking for. 

When I choose "Show as table", the value of each part number is displayed. See below.

While the data i would need to display in the table are the ones indicated in the Black table. 

This data are visible when we put our cursor on the chart.

Hope we could find a solution.

[KBO]

Hi @Kdriss ,

which visual do you use?

MSFT actually shipped this feature already! It was included as part of our July update to Power BI Desktop. You can read all about it in the blog: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2018-feature-summary/#tooltips

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Kdriss]

Hi Kathrin,

Thanks for your answer but even if the tooltips turnon, I cannot see the median, 1st and 3 rd quartile in a spearte table.

Here is the filters i have used, do you think is correct

[KBO]

Hi @Kdriss ,

hmmm... If I see the screenshot I ask myself what would you do XD

You add to the tooltip the same column which you have already in your visual...

Try this: https://www.youtube.com/watch?v=URTA7JZsAtw 

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Kdriss]

Thanks again

I have tried but I have not been able to get the results in the dashboard. I am not sure thsi works for Box and Whiskers..

I am not sure if we can get the data I am looking for in a separate table using sampling.. 

Let me know if you have other suggestions

Best regards