Histogram in Power BI

[csaethre19]

I need to create a histogram using Power BI but it appears there is no histogram visualization to choose from. Everytime I try to find resources online I find tutorials explaining how to import a Microsoft visualization for a histogram, but I cannot find this particular one - it just isn't available. I get two other options, both of which do not seem to work and I can't find any resources on how to use them. Does anyone know how to create a pretty basic histogram in Power BI desktop?

[almudenaarcinie]

Hello,

I am facing issues to get the next. I have a table with WOT per Maintenance Name and Creation date and I have the Task Duration. I would like to create a Histogram with the distribution of data to be the next :

IF(Duration < AvgDuration * 0.25, "0-25% of the Average",
IF(Duration < AvgDuration * 0.5, "25-50% of the Average",
IF(Duration < AvgDuration * 0.75, "50-75% of the Average",
IF(Duration < AvgDuration * 1.25, "75-125% of the Average",
IF(Duration < AvgDuration * 1.75, "125%-175% of the Average",
"175%- of the Average"

In order to display the number of WOT that are in each range. Could you give me some support on this? I can't find a way. 

Please find the table as a database. I would also be able to filter the Histofra by Maintenance Type or Created date. Thanks for your support

Number	State WOT	Work Start	Maintenance Type	Created On	Closed At	Work End	Task Duration (hours)
WOT0579630	3	22/01/2025 16:04	calibration	22/01/2025 16:02	22/01/2025 16:09	22/01/2025 16:09	0,09
WOT0571105	3	02/01/2025 11:22	audit	02/01/2025 10:53	02/01/2025 11:22	02/01/2025 11:22	0,01
WOT0584768	3	03/02/2025 18:16	audit	03/02/2025 10:57	03/02/2025 18:17	03/02/2025 18:17	0
WOT0571098	3	02/01/2025 11:25	audit	02/01/2025 10:45	02/01/2025 11:25	02/01/2025 11:25	0
WOT0578982	3	21/01/2025 12:01	audit	21/01/2025 11:55	21/01/2025 12:34	21/01/2025 12:34	0,55
WOT0584767	3	03/02/2025 18:12	audit	03/02/2025 10:57	03/02/2025 18:15	03/02/2025 18:15	0,06
WOT0583244	3	30/01/2025 12:11	audit	30/01/2025 12:07	30/01/2025 12:32	30/01/2025 12:32	0,36
WOT0571091	3	02/01/2025 11:27	audit	02/01/2025 10:36	02/01/2025 11:27	02/01/2025 11:27	0,01
WOT0580405	3	24/01/2025 11:36	audit	24/01/2025 11:34	24/01/2025 11:53	24/01/2025 11:53	0,28
WOT0580406	3	24/01/2025 11:53	audit	24/01/2025 11:34	24/01/2025 11:54	24/01/2025 11:54	0,01
WOT0583235	3	30/01/2025 11:46	audit	30/01/2025 11:45	30/01/2025 11:46	30/01/2025 11:46	0,01
WOT0584135	3	02/02/2025 6:16	audit	02/02/2025 6:13	02/02/2025 8:12	02/02/2025 8:12	1,93
WOT0572021	3	05/01/2025 19:06	audit	05/01/2025 18:10	05/01/2025 22:25	05/01/2025 22:25	3,33
WOT0581705	3	27/01/2025 15:28	audit	27/01/2025 15:27	27/01/2025 18:46	27/01/2025 18:46	3,3
WOT0574611	3	10/01/2025 18:31	audit	10/01/2025 18:28	10/01/2025 21:04	10/01/2025 21:04	2,56
WOT0583806	3	31/01/2025 17:44	audit	31/01/2025 16:22	31/01/2025 19:34	31/01/2025 19:34	1,83
WOT0585010	3	03/02/2025 15:06	audit	03/02/2025 15:05	03/02/2025 18:31	03/02/2025 18:31	3,41
WOT0571816	3	04/01/2025 10:53	audit	04/01/2025 9:11	04/01/2025 13:18	04/01/2025 13:18	2,42
WOT0580517	3	24/01/2025 15:52	audit	24/01/2025 15:50	24/01/2025 18:06	24/01/2025 18:06	2,23
WOT0581978	3	28/01/2025 6:19	calibration	28/01/2025 6:18	28/01/2025 6:19	28/01/2025 6:19	0
WOT0581973	3	28/01/2025 6:15	calibration	28/01/2025 6:14	28/01/2025 6:15	28/01/2025 6:15	0,01
WOT0581894	3	28/01/2025 3:18	calibration	28/01/2025 3:18	28/01/2025 3:19	28/01/2025 3:19	0,01
WOT0581897	3	28/01/2025 3:26	calibration	28/01/2025 3:25	28/01/2025 3:26	28/01/2025 3:26	0
WOT0582019	3	28/01/2025 6:50	calibration	28/01/2025 6:49	28/01/2025 6:50	28/01/2025 6:50	0
WOT0581992	3	28/01/2025 6:27	calibration	28/01/2025 6:26	28/01/2025 6:27	28/01/2025 6:27	0,01
WOT0581899	3	28/01/2025 3:29	calibration	28/01/2025 3:28	28/01/2025 3:29	28/01/2025 3:29	0
WOT0584512	3	03/02/2025 4:07	calibration	03/02/2025 4:07	03/02/2025 4:08	03/02/2025 4:08	0
WOT0584506	3	03/02/2025 4:02	calibration	03/02/2025 4:01	03/02/2025 4:02	03/02/2025 4:02	0
WOT0582014	3	28/01/2025 6:44	calibration	28/01/2025 6:43	28/01/2025 6:44	28/01/2025 6:44	0
WOT0582005	3	28/01/2025 6:38	calibration	28/01/2025 6:38	28/01/2025 6:38	28/01/2025 6:38	0
WOT0582033	3	28/01/2025 7:05	calibration	28/01/2025 7:03	28/01/2025 7:05	28/01/2025 7:05	0
WOT0582018	3	28/01/2025 6:47	calibration	28/01/2025 6:46	28/01/2025 6:48	28/01/2025 6:48	0
WOT0581981	3	28/01/2025 6:21	calibration	28/01/2025 6:20	28/01/2025 6:21	28/01/2025 6:21	0
WOT0582026	3	28/01/2025 6:59	calibration	28/01/2025 6:58	28/01/2025 7:00	28/01/2025 7:00	0
WOT0584514	3	03/02/2025 4:10	calibration	03/02/2025 4:09	03/02/2025 4:10	03/02/2025 4:10	0
WOT0581971	3	28/01/2025 6:13	calibration	28/01/2025 6:12	28/01/2025 6:13	28/01/2025 6:13	0
WOT0581908	3	28/01/2025 3:44	calibration	28/01/2025 3:43	28/01/2025 3:44	28/01/2025 3:44	0
WOT0585140	3	04/02/2025 2:34	calibration	04/02/2025 2:33	04/02/2025 2:34	04/02/2025 2:34	0
WOT0584513	3	03/02/2025 4:09	calibration	03/02/2025 4:08	03/02/2025 4:09	03/02/2025 4:09	0
WOT0584509	3	03/02/2025 4:05	calibration	03/02/2025 4:04	03/02/2025 4:05	03/02/2025 4:05	0
WOT0581903	3	28/01/2025 3:33	calibration	28/01/2025 3:32	28/01/2025 3:34	28/01/2025 3:34	0

[iamkhushisingh]

My hack is that I reduce the spacing between the columns to make it look like a histogram. 

Format Visual -> Visual Tab -> Columns -> Layout -> Spacing between columns [0 or 1 %]

[PhilipTreacy · Accepted solution]

Hi @csaethre19 

Download example PBIX file

If you want to use the in-built Clustered Column visual, you can create your own bins.

In my example file I've used this data, and added a column for the Bin.  Each bin respresents $1000 more in sales.

Then plot the Bin on the x-axis and the Count of Bin on the y-axis (I've renamed the axes)

Your approach would be similar with your data.

Regards

Phil

[csaethre19]

I will try this out! Thank you

[PhilipTreacy]

Hi @csaethre19 

If I go to More Visuals -> From AppSource and then search for Histogram, I get 2 results.  You don't?

Regards

Phil

[csaethre19]

I get those same two results. I just don't understand how to use them and any tutorial I find online mentions a histogram that is built by Microsoft and looks much easier to use.