topic Re: Box and Whisker Plot in Developer

Box and Whisker Plot

tjd — Thu, 20 Jul 2017 18:05:09 GMT

Any idea when the revised visual will be loaded to the store? Right now there is none and, it appears, a revision is about to come out but nothing can be downloaded now from the store.

Re: Box and Whisker Plot

v-viig — Fri, 21 Jul 2017 08:42:26 GMT

Hello @tjd,

Box Whisker is in Office Store. Heve you faced any issues with this visual?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Box and Whisker Plot

tjd — Fri, 21 Jul 2017 11:06:00 GMT

It wasn't there when I made the post yesterday. It is now there. Seems as though you guys are arbitrarily taking down visuals and putting them back up. Now, the Long Text Viewer has gone missing. You keep this up and people will quickly lose faith in having a custom visual available for users to download and will stop using them in their PowerBI applications.

Re: Box and Whisker Plot

jppp — Fri, 21 Jul 2017 12:03:19 GMT

Indeed the store entry was missing for +/- one day. When I submitted the new version I set a date in the future expecting that the old version was still available before that date. But it didn't. Luckally it was only a small period.

Thanks, Jan Pieter

Re: Box and Whisker Plot

tjd — Fri, 21 Jul 2017 19:33:28 GMT

@jpppUnfortunately, while the Office Store now says version 2.0.0.0 is the new Box and Whisker Plot download, when I download it (shows v.2.0.0.0 in the name) and bring it into PowerBI desktop, it appears to be the old version. None of your new "stuff" is showing up per your website. Any idea what's going on?

Re: Box and Whisker Plot

jppp — Sat, 22 Jul 2017 09:11:06 GMT

@tjd, this is correct at this moment. It takes +/-2 weeks before new visuals are available for everybody after store approval. This is needed to assure that existing reports are not breaking. But indeed there is now a strange situation that the store entry is of the new version and you can use the old version. But is +/- 2 weeks your reports are updated automatically.

Re: Box and Whisker Plot

jppp — Tue, 01 Aug 2017 06:22:53 GMT

Hi, just a quick notice: the new version is now available for everyone.

If you have further questions, feel free to ask.

-JP

Re: Box and Whisker Plot

tjd — Tue, 01 Aug 2017 12:05:01 GMT

Thanks for the update.

Re: Box and Whisker Plot

yuxuan007586 — Fri, 18 Aug 2017 14:38:24 GMT

Hi!

I faced some problems for the newest version. I downlaoded the nest version of power bi destop, but it doesn't work. Can you please help? Thank you.

1. No chart showing after I drop vlaues and catefory

2. I cannot put multiple values

3. "Don't summarize" is not avaliable

Re: Box and Whisker Plot

jppp — Fri, 18 Aug 2017 15:23:17 GMT

Hi,

The Box and Whisker chart needs data is a specific way.

Category - This field contains the categories. For each (unique) category a different chart is drawn.
Sampling - All these fields are being used to 'sample' the dataset or 'creates rows'.
Values - The values field contains a numeric value to calculate the statistic values needed for the charts.

This is also the reason that the option 'Don't summarize' is not available for this chart: it is how the data is bound to the visual and that is needed for a next release when there will be support for drill-down.

Multiple values is not supported: the chart only uses one measure for calculation the needed values.

Or do you have a scenario where you need to have multiple measures in one box and whisker chart?

-JP

Re: Box and Whisker Plot

yuxuan007586 — Fri, 18 Aug 2017 16:03:28 GMT

That works! Another question is for outliers, when I hover a outlier point, it only shows values and category, but no samplinmg fields showing.

For example, I put "Platform" into Category, "Date" into Sampling and "Revenue" into Values. And I want also show "Date" in outliers point detials when I hover my mouse.

How can I resolve this? Thank you so much.

Re: Box and Whisker Plot

jppp — Fri, 18 Aug 2017 16:22:42 GMT

At this moment this information is not exposed in the details.

But what kind of information do you like to see? All the fields used to sample the data, e.g. sampling: date?

And do you like to see that information also in chart details?

Re: Box and Whisker Plot

yuxuan007586 — Fri, 18 Aug 2017 16:30:04 GMT

Exactly! I'd like to see all fields used in sampling in outliers and chart details. In addition, it would be the best if the chart can show every data point. Thank you very much.

Re: Box and Whisker Plot

jppp — Fri, 18 Aug 2017 16:35:33 GMT

Thanks for the suggestion and I will put it on my backlog: https://github.com/liprec/powerbi-boxWhiskerChart/issues/3

-JP

Re: Box and Whisker Plot

Koikby — Mon, 25 Sep 2017 11:04:30 GMT

Hi there. Not sure if this is down to my error, but on my box and whisker chart, when I hover my cursor over each outlier the value which appears is always the lowest outlier value. For example, my lowest outlier in a chart is 9 seconds, my highest is 1237 seconds, however when I hover over the 1237 seconds outlier the value shows as 9 seconds. Am I doing something incorrect or is there a fault?

Re: Box and Whisker Plot

jppp — Sun, 01 Oct 2017 10:57:10 GMT

Hi,

Thanks for the feedback and indeed there is an issue with the labeling of the outliers.

I will fix this in the upcoming release, which will be in a few weeks.

Thanks, Jan Pieter

Re: Box and Whisker Plot

comish4lif — Wed, 01 Nov 2017 13:53:10 GMT

Sampling. Can I edit the sampling?

I have created a Box and Whisker on "Salary" for all employees.

The "# samples" value is 30,000. Can I edit that to include all employees (~49K)?

Also - "Category" is required to be populated. What would I do there if I wanted a corporate wide figure and didn't wish to break it down by any category?

Re: Box and Whisker Plot

jppp — Wed, 08 Nov 2017 13:52:40 GMT

Sorry, but the ~30K limit is a limit of Power BI and not of the visual, so there is no way to raise it.

And the 'Category' was optional, but I believe that it didn't made it to the latest version. I will look into this and it will be back in a future release.

-JP

Re: Box and Whisker Plot

bhanudaybirla — Tue, 26 Dec 2017 06:37:01 GMT

Hi, I am having 25000 rows in my data set and it will be growing day by day. With this much of data it is taking too much time to load a boxplot having only one category. How can i make this faster?

Re: Box and Whisker Plot

bhanudaybirla — Tue, 26 Dec 2017 06:39:44 GMT

Hi, I have 25k rows in my data and the boxplot is taking too much time to load. Can we make it faster with some standard tricks?