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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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/

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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