Forum Discussion
Power Participantbox and whisker visualisation
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.
Power ParticipantThanks v-jiascu-msft
I understamd it a bit better now. I actually didn't want any sampling so I used an index column which worked! ......but!
It made the chart really really slow. So slow it was unusable. I also was unable to change the data colours and because it was taking minutes for each update I had to give up.
Shame really but I think there was to much data for it in this case.
Thanks for your help.
Microsoft EmployeeHi 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
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
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.