Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
csaethre19
Helper II
Helper II

Histogram in Power BI

‎06-19-2023 11:57 AM

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?

Labels:
Message 1 of 7
51,676 Views
0
1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

‎06-19-2023 04:47 PM

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.

 

histbin.png

 

 

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

 

hists.png

 

Your approach would be similar with your data.

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Message 4 of 7
51,630 Views
6 REPLIES 6
almudenaarcinie
New Member

‎02-04-2025 08:09 AM

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

NumberState WOTWork StartMaintenance TypeCreated OnClosed AtWork EndTask Duration (hours)
WOT0579630322/01/2025 16:04calibration22/01/2025 16:0222/01/2025 16:0922/01/2025 16:090,09
WOT0571105302/01/2025 11:22audit02/01/2025 10:5302/01/2025 11:2202/01/2025 11:220,01
WOT0584768303/02/2025 18:16audit03/02/2025 10:5703/02/2025 18:1703/02/2025 18:170
WOT0571098302/01/2025 11:25audit02/01/2025 10:4502/01/2025 11:2502/01/2025 11:250
WOT0578982321/01/2025 12:01audit21/01/2025 11:5521/01/2025 12:3421/01/2025 12:340,55
WOT0584767303/02/2025 18:12audit03/02/2025 10:5703/02/2025 18:1503/02/2025 18:150,06
WOT0583244330/01/2025 12:11audit30/01/2025 12:0730/01/2025 12:3230/01/2025 12:320,36
WOT0571091302/01/2025 11:27audit02/01/2025 10:3602/01/2025 11:2702/01/2025 11:270,01
WOT0580405324/01/2025 11:36audit24/01/2025 11:3424/01/2025 11:5324/01/2025 11:530,28
WOT0580406324/01/2025 11:53audit24/01/2025 11:3424/01/2025 11:5424/01/2025 11:540,01
WOT0583235330/01/2025 11:46audit30/01/2025 11:4530/01/2025 11:4630/01/2025 11:460,01
WOT0584135302/02/2025 6:16audit02/02/2025 6:1302/02/2025 8:1202/02/2025 8:121,93
WOT0572021305/01/2025 19:06audit05/01/2025 18:1005/01/2025 22:2505/01/2025 22:253,33
WOT0581705327/01/2025 15:28audit27/01/2025 15:2727/01/2025 18:4627/01/2025 18:463,3
WOT0574611310/01/2025 18:31audit10/01/2025 18:2810/01/2025 21:0410/01/2025 21:042,56
WOT0583806331/01/2025 17:44audit31/01/2025 16:2231/01/2025 19:3431/01/2025 19:341,83
WOT0585010303/02/2025 15:06audit03/02/2025 15:0503/02/2025 18:3103/02/2025 18:313,41
WOT0571816304/01/2025 10:53audit04/01/2025 9:1104/01/2025 13:1804/01/2025 13:182,42
WOT0580517324/01/2025 15:52audit24/01/2025 15:5024/01/2025 18:0624/01/2025 18:062,23
WOT0581978328/01/2025 6:19calibration28/01/2025 6:1828/01/2025 6:1928/01/2025 6:190
WOT0581973328/01/2025 6:15calibration28/01/2025 6:1428/01/2025 6:1528/01/2025 6:150,01
WOT0581894328/01/2025 3:18calibration28/01/2025 3:1828/01/2025 3:1928/01/2025 3:190,01
WOT0581897328/01/2025 3:26calibration28/01/2025 3:2528/01/2025 3:2628/01/2025 3:260
WOT0582019328/01/2025 6:50calibration28/01/2025 6:4928/01/2025 6:5028/01/2025 6:500
WOT0581992328/01/2025 6:27calibration28/01/2025 6:2628/01/2025 6:2728/01/2025 6:270,01
WOT0581899328/01/2025 3:29calibration28/01/2025 3:2828/01/2025 3:2928/01/2025 3:290
WOT0584512303/02/2025 4:07calibration03/02/2025 4:0703/02/2025 4:0803/02/2025 4:080
WOT0584506303/02/2025 4:02calibration03/02/2025 4:0103/02/2025 4:0203/02/2025 4:020
WOT0582014328/01/2025 6:44calibration28/01/2025 6:4328/01/2025 6:4428/01/2025 6:440
WOT0582005328/01/2025 6:38calibration28/01/2025 6:3828/01/2025 6:3828/01/2025 6:380
WOT0582033328/01/2025 7:05calibration28/01/2025 7:0328/01/2025 7:0528/01/2025 7:050
WOT0582018328/01/2025 6:47calibration28/01/2025 6:4628/01/2025 6:4828/01/2025 6:480
WOT0581981328/01/2025 6:21calibration28/01/2025 6:2028/01/2025 6:2128/01/2025 6:210
WOT0582026328/01/2025 6:59calibration28/01/2025 6:5828/01/2025 7:0028/01/2025 7:000
WOT0584514303/02/2025 4:10calibration03/02/2025 4:0903/02/2025 4:1003/02/2025 4:100
WOT0581971328/01/2025 6:13calibration28/01/2025 6:1228/01/2025 6:1328/01/2025 6:130
WOT0581908328/01/2025 3:44calibration28/01/2025 3:4328/01/2025 3:4428/01/2025 3:440
WOT0585140304/02/2025 2:34calibration04/02/2025 2:3304/02/2025 2:3404/02/2025 2:340
WOT0584513303/02/2025 4:09calibration03/02/2025 4:0803/02/2025 4:0903/02/2025 4:090
WOT0584509303/02/2025 4:05calibration03/02/2025 4:0403/02/2025 4:0503/02/2025 4:050
WOT0581903328/01/2025 3:33calibration28/01/2025 3:3228/01/2025 3:3428/01/2025 3:340
Message 7 of 7
18,998 Views
0
iamkhushisingh
New Member

‎01-09-2025 09:30 AM

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 %]

Message 6 of 7
21,996 Views
0
PhilipTreacy
Super User
Super User

‎06-19-2023 04:47 PM

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.

 

histbin.png

 

 

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

 

hists.png

 

Your approach would be similar with your data.

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Message 4 of 7
51,631 Views
csaethre19
Helper II
Helper II
In response to PhilipTreacy

‎06-20-2023 07:06 AM

I will try this out! Thank you

Message 5 of 7
51,624 Views
PhilipTreacy
Super User
Super User

‎06-19-2023 04:34 PM

Hi @csaethre19 

 

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

 

hist.png

Regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Message 2 of 7
51,632 Views
0
csaethre19
Helper II
Helper II
In response to PhilipTreacy

‎06-20-2023 07:06 AM

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. 

Message 3 of 7
51,624 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

View All