cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Box and Whisker Chart preparation company vise

Hi

 

I have company vise resposnes over a survey and have received data on components company vise.

 

Comp Component Revenue

ABC    Revenue      100000  

XYZ     Revenue      15000

 

Similar kind I have data for about 20 companies.

 

I want to show the top median lower quartile as in Box and Whisker chart.

I also want to show it specific company vise. But i am not able to get it done company vise

9 REPLIES 9
Regular Visitor

Hi @Icey 

 

I am getting the same solution as you posted but when I filter out a single company I do not want the visual to show only single line as you shared in the screenshot.

Is it possible that the visual shows quartiles as per whole data and the show the specific company where it lies in the entire range

 

 

Regular Visitor

Hi @Icey

Data Set:

Company NameComponentYearBucketMetrics Value
ABCComp 12018$1B-$5BMetric 11000000
XYZComp 12018$1B-$5BMetric 138374663
ABCComp 12019$1B-$5BMetric 12837736
XYZComp 12019$1B-$5BMetric 1383763
ABCComp 12020$1B-$5BMetric 12773636
XYZComp 12020$1B-$5BMetric 13273663
ABCComp 22018$1B-$5BMetric 2146493000
XYZComp 22018$1B-$5BMetric 2514441998
ABCComp 22019$1B-$5BMetric 2126648000
XYZComp 22019$1B-$5BMetric 2280125348.5
ABCComp 22020$1B-$5BMetric 2118706000
XYZComp 22020$1B-$5BMetric 2173067199
ABCComp 42018$1B-$5BMetric 4302996800
XYZComp 42018$1B-$5BMetric 483873
ABCComp 42019$1B-$5BMetric 4298400390
XYZComp 42019$1B-$5BMetric 4334566356
ABCComp 42020$1B-$5BMetric 4300011600
XYZComp 42020$1B-$5BMetric 4775435678
ABCComp 32018$1B-$5BMetric 3712042480
XYZComp 32018$1B-$5BMetric 32481409070
ABCComp 32019$1B-$5BMetric 3635722570
XYZComp 32019$1B-$5BMetric 32042211488
ABCComp 32020$1B-$5BMetric 3460732100
XYZComp 32020$1B-$5BMetric 31538984995

In the box whisker, I need the Visual - Component vise showing individual company standing by considering the quartiles on the overall data.

Community Support
Community Support

Hi @pranit1997 ,

 

The cause is what I mentioned above, only with one record.

box1.JPGbox2.JPG

 

 

Best Regards,

Icey

 

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

@Icey

Hey Can You help me out?

Community Support
Community Support

Hi @pranit1997 ,

 

If the above method doesn't work either, please share us your .pbix file. Please remove sensitive information. It is suggested to upload it to OneDrive for Business and then paste the link here.

 

 

Best Regards,

Icey

Hey @Icey

I tried what you shared in the last post to create a Unique ID. But still didnt receive the output.

I have attached the sample file.

Community Support
Community Support

Hi @pranit1997 ,

 

Please check whether your data has at least two values of each Company, each Component and each Year, otherwise it is normal for the situation you mentioned to occur.

 

In addition, I have no access to your file. Please give me access.

 

 

Best Regards,

Icey

 

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

Community Support
Community Support

Hi @pranit1997 ,

 

Please create a Unique Key field, such as an Index column, and then put it into "Axis" field.

box - index.JPG

 

Then, please make sure that your data has at least two values after each filter, otherwise it is normal for the situation you mentioned to occur.

 

My test data:

Company Component Revenue Year Index
ABC Revenue1 100000 2019 1
XYZ Revenue1 150000 2019 2
ABC Revenue2 200000 2019 3
XYZ Revenue2 100000 2019 4
ABC Revenue1 150000 2020 5
XYZ Revenue1 200000 2020 6
ABC Revenue2 180000 2020 7
XYZ Revenue2 150000 2020 8
ABC Revenue1 200000 2019 9
XYZ Revenue1 350000 2019 10
ABC Revenue2 150000 2019 11
XYZ Revenue2 200000 2019 12
ABC Revenue1 300000 2020 13
XYZ Revenue1 250000 2020 14
ABC Revenue2 300000 2020 15
XYZ Revenue2 200000 2020 16

 

 

Then, you'll get what you want.

box.gif

 

 

Best Regards,

Icey

 

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

Regular Visitor

Here is the chart that I prepared:

pranit1997_0-1603793541842.png

Here it is showing for all companies together.

But I want the median top and lower quartile for a single company. When I filter on the company, my visual shows a straight line only.

 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors