Hi David, Thanks for the response and comment. The examples from the video are a way of using the Box and Whisker charts. But of course you could experiment with other combinations. Such as "Project budget" as the value / Y axis, and then "Project location" on the X axis. This will give you an indication if a specific location is more expensive, of if a specific location has a bigger budget spread then the others The thing, is that it depends on the spread of the data that you want to analyze.
Hi Piyushsingh, that's true. I'm using a measure on that timeslot. Here's the formula from the DAX: Duration = CALCULATE ( SUM ( msdyn_project[msdyn_duration] ) ) Hope this clears up the section. Thanks for your comment.
Is there a way to invert the Y axis? My data deal with rankings, so I would like the Y axis to cross the X axis at the largest value so that I can better indicate that a decrease in rank is actually an increase in quality.
Hi Tmivy, sorry for the late response. I don't aee a direct option but could figure there are alternative options. I believe one is called a bullet chart. That might help, if you know of an alternative let me know I might be able to provide a follow up video
👉 Watch next - Exploring the Chiclet Slicer visual in Power BI ua-cam.com/video/3WKYIO4qEXM/v-deo.html
Average or mean is a sum of sample values divided by number of samples, median is the second quartile, a number dividing population by half
Good stuff.
Please augment explanation on exactly what goes to what axis etc. The visual got multiple axis and its good to understand that.
Hi David,
Thanks for the response and comment. The examples from the video are a way of using the Box and Whisker charts. But of course you could experiment with other combinations. Such as "Project budget" as the value / Y axis, and then "Project location" on the X axis. This will give you an indication if a specific location is more expensive, of if a specific location has a bigger budget spread then the others The thing, is that it depends on the spread of the data that you want to analyze.
Man you should clarify whether you used measures or not at 8:33, otherwise if the data is not prepared correctly we will not see individual dots
Hi Piyushsingh, that's true. I'm using a measure on that timeslot.
Here's the formula from the DAX:
Duration =
CALCULATE ( SUM ( msdyn_project[msdyn_duration] ) )
Hope this clears up the section. Thanks for your comment.
Is there a way to invert the Y axis? My data deal with rankings, so I would like the Y axis to cross the X axis at the largest value so that I can better indicate that a decrease in rank is actually an increase in quality.
Hi Tmivy, sorry for the late response. I don't aee a direct option but could figure there are alternative options. I believe one is called a bullet chart. That might help, if you know of an alternative let me know I might be able to provide a follow up video