Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
| SN | DateTime | DataValue |
| 50001 | 1/14/2020 | 0.1776 |
| 50001 | 1/14/2020 | 0.1533 |
| 50001 | 1/14/2020 | 0.179 |
| 50001 | 1/14/2020 | 0.1775 |
| 50001 | 1/14/2020 | 0.124 |
| 50001 | 1/14/2020 | 0.1023 |
| 50001 | 1/14/2020 | 0.0964 |
| 50001 | 1/14/2020 | 0.0998 |
| 50001 | 1/14/2020 | 0.0977 |
| 50001 | 1/14/2020 | 0.1022 |
| 50001 | 1/14/2020 | 0.1028 |
| 50001 | 1/14/2020 | 0.1874 |
| 50001 | 1/14/2020 | 0.1056 |
| 50001 | 1/14/2020 | 0.1849 |
| 50001 | 1/14/2020 | 0.1583 |
| 50001 | 1/14/2020 | 0.1694 |
| 50001 | 1/14/2020 | 0.1484 |
| 50001 | 1/14/2020 | 0.1791 |
| 50001 | 1/14/2020 | 0.1762 |
| 50001 | 1/14/2020 | 0.1726 |
| 50002 | 1/2/2020 | 0.1728 |
| 50002 | 1/2/2020 | 0.1509 |
| 50002 | 1/2/2020 | 0.1306 |
| 50002 | 1/2/2020 | 0.1298 |
| 50002 | 1/2/2020 | 0.1086 |
| 50002 | 1/2/2020 | 0.1215 |
| 50002 | 1/2/2020 | 0.1171 |
| 50002 | 1/2/2020 | 0.1007 |
| 50002 | 1/2/2020 | 0.1006 |
| 50002 | 1/2/2020 | 0.1161 |
| 50002 | 1/2/2020 | 0.1237 |
| 50002 | 1/2/2020 | 0.167 |
| 50002 | 1/2/2020 | 0.1101 |
| 50002 | 1/2/2020 | 0.1925 |
| 50002 | 1/2/2020 | 0.1915 |
| 50002 | 1/2/2020 | 0.1448 |
| 50002 | 1/2/2020 | 0.1243 |
| 50002 | 1/2/2020 | 0.1785 |
| 50002 | 1/2/2020 | 0.1508 |
| 50002 | 1/2/2020 | 0.1815 |
| 50003 | 1/2/2020 | 0.2 |
| 50003 | 1/2/2020 | 0.1602 |
| 50003 | 1/2/2020 | 0.1692 |
| 50003 | 1/2/2020 | 0.1369 |
| 50003 | 1/2/2020 | 0.1047 |
| 50003 | 1/2/2020 | 0.0999 |
| 50003 | 1/2/2020 | 0.1094 |
| 50003 | 1/2/2020 | 0.1178 |
| 50003 | 1/2/2020 | 0.102 |
| 50003 | 1/2/2020 | 0.1138 |
| 50003 | 1/2/2020 | 0.1042 |
| 50003 | 1/2/2020 | 0.1984 |
| 50003 | 1/2/2020 | 0.0964 |
| 50003 | 1/2/2020 | 0.1989 |
| 50003 | 1/2/2020 | 0.1875 |
| 50003 | 1/2/2020 | 0.1617 |
| 50003 | 1/2/2020 | 0.1596 |
| 50003 | 1/2/2020 | 0.1903 |
| 50003 | 1/2/2020 | 0.1812 |
| 50003 | 1/2/2020 | 0.1733 |
PQ Histogram
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
@Anonymous , make sure you in data format you give decimal place.
Refer if this can help
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 130 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |