Forum Discussion
Box and Whisker Plot
Does anyone know if we can use a measure in one of the available box and whisker plots? I tried it and it does not work for me. It only works when I pick a value from one of the columns.
If we can’t use measures is there a workaround?
Thanks
Hi MarcelloPetacci ,
For three data fields in Box and Whisker Plot:
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.
So you can only put measure value in Values field. Would you please try to use calculated column instead of measure in your situation?
For more details, please refer to https://azurebi-docs.jppp.org/powerbi-visuals/box-and-whisker-chart.html?tabs=docs%2Cdocs-open and https://www.youtube.com/watch?v=BHmYFBujgak
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
1 Reply
v-deddai1-msftCommunity Support
Hi MarcelloPetacci ,
For three data fields in Box and Whisker Plot:
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.
So you can only put measure value in Values field. Would you please try to use calculated column instead of measure in your situation?
For more details, please refer to https://azurebi-docs.jppp.org/powerbi-visuals/box-and-whisker-chart.html?tabs=docs%2Cdocs-open and https://www.youtube.com/watch?v=BHmYFBujgak
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai