Forum Discussion

gooranga1's avatar
gooranga1
Icon for Power Participant rankPower Participant
8 years ago
Solved

box and whisker visualisation

I don't have much experience with box and whisker plots and I am struggling to make the results returned in it to the measures I have created on the same data. I have used MEDIAN and AVERAGE in the f...
Need Help
  • gooranga1's avatar
    gooranga1
    8 years ago

    I ended up using the R visualisation and used ggplot2 library using geom_boxplot which after a bit of messing about does the job.

     

    The R plotly library looks to have more featues and allows data labels. I could get it to work in R Studio but it didn't seem to work in power bi very well which was a shame.

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi gooranga1,

 

Maybe you can try to summarize the data first, there could be less computing. In my example, I can try to create a new table like this.

Table 4 =
SUMMARIZE (
    'Sales',
    'Product'[Color],
    Sales[Quantity],
    "sumQuantity", SUM ( Sales[Quantity] )
)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

gooranga1's avatar
gooranga1
Icon for Power Participant rankPower Participant
8 years ago

Thanks v-jiascu-msft

 

I did have a think how I could summarise the data but not sure I can. We have thousands of doors that can get opended multiple times in a day. We would like to get acurate overview of the opening times of the doors. Not sure how I could summarise that data to get this as I think I need the raw data to get acurate figures. I will keep looking at it though and see If I can find a way to do this.

 

Cheers

  • gooranga1's avatar
    gooranga1
    Icon for Power Participant rankPower Participant
    8 years ago

    I ended up using the R visualisation and used ggplot2 library using geom_boxplot which after a bit of messing about does the job.

     

    The R plotly library looks to have more featues and allows data labels. I could get it to work in R Studio but it didn't seem to work in power bi very well which was a shame.