From the course: Power BI Challenges: 15 Skills-Building Analytics Exercises for Data Professionals

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Solution

Solution - Power BI Tutorial

From the course: Power BI Challenges: 15 Skills-Building Analytics Exercises for Data Professionals

Start my 1-month free trial Buy for my team

Solution

“

(upbeat music) - [Instructor] So how was that for you? What did you go for? I decided to create a histogram in a completely new tab. When it comes to statistics, I find that the audience generally can make sense of histograms far more easily than other statistical visuals, such as box plots. Lots of people just haven't got a clue what a box plot means. And there are box plots that you can get, by the way, as custom visuals from AppSource, but there aren't any as standard. So I'm going to show you how to make a histogram in two different ways. The first is by creating a calculated column that assigns bins to each rows. I'm going to have 10 buckets in 100K sizes. There's lots of different ways of doing this. One is to create a new table with as many rows as buckets, and then you can use DAX to calculate the counts against each bin. This can be really good if you need dynamic groupings, you know, if the bucket sizes are…

Contents