Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Histogram by PQ Systems

I am trying to create a histogram by importing SPC hisotgram. I am unable to find any clear documentation. I am trying to

plot datavalue in value field and date in order field but it is just giving me a single line. I have used the other hisotgram and it looks perfectly shaped but i am unbale to figure out how to make SPC histogram look correct. can someone please help 

 This is something how my data looks as below. I am taking count of Datavalue as frequency and Datavalue in Values field of green histogram below. I am using the same Datavalue in Values field but unable to genrate a proper histogram

 

SNDateTimeDataValue
500011/14/20200.1776
500011/14/20200.1533
500011/14/20200.179
500011/14/20200.1775
500011/14/20200.124
500011/14/20200.1023
500011/14/20200.0964
500011/14/20200.0998
500011/14/20200.0977
500011/14/20200.1022
500011/14/20200.1028
500011/14/20200.1874
500011/14/20200.1056
500011/14/20200.1849
500011/14/20200.1583
500011/14/20200.1694
500011/14/20200.1484
500011/14/20200.1791
500011/14/20200.1762
500011/14/20200.1726
500021/2/20200.1728
500021/2/20200.1509
500021/2/20200.1306
500021/2/20200.1298
500021/2/20200.1086
500021/2/20200.1215
500021/2/20200.1171
500021/2/20200.1007
500021/2/20200.1006
500021/2/20200.1161
500021/2/20200.1237
500021/2/20200.167
500021/2/20200.1101
500021/2/20200.1925
500021/2/20200.1915
500021/2/20200.1448
500021/2/20200.1243
500021/2/20200.1785
500021/2/20200.1508
500021/2/20200.1815
500031/2/20200.2
500031/2/20200.1602
500031/2/20200.1692
500031/2/20200.1369
500031/2/20200.1047
500031/2/20200.0999
500031/2/20200.1094
500031/2/20200.1178
500031/2/20200.102
500031/2/20200.1138
500031/2/20200.1042
500031/2/20200.1984
500031/2/20200.0964
500031/2/20200.1989
500031/2/20200.1875
500031/2/20200.1617
500031/2/20200.1596
500031/2/20200.1903
500031/2/20200.1812
500031/2/20200.1733

h.PNGPQ HistogramPQ Histogram

 

3 REPLIES 3
asitm
Helper III
Helper III

I am able to create the histogram based on your data using other available custom visuals

https://appsource.microsoft.com/en-us/product/power-bi-visuals/histogramstd

asitm_0-1699452804806.png

 

amitchandak
Super User
Super User

@Anonymous , make sure you in data format you give decimal place.

Refer if this can help

https://spreadsheeto.com/power-bi-histogram/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

My data is alrady in decimal format , column name datavalue. The link you posted is for the histogram i am able to generate. I am unable ti genrate the PQ histogram. I am not sure what mistake i am doing @amitchandak  can you please help.

 

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200001046?src=office&tab=Overview

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.