cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shivenra
New Member

Histogram frequency not appearing but data is correct

Hi,

 

im trying to produce a histogram, works with other values, however the value in one of the frequencies is not appearing.

 

Graph.PNG

Here is the data set, 277763.7 is not appearing

 

DateAmount
2019050117710.17
20190504277763.7
20190505-12079.9
2019050639279.71
2019050742009.08
2019050825476.85
20190511-1
2019051225836.73
201905132049.053
20190514-15212
20190515-56219.8
2019051821556.88
20190519-168305
2019052017892.1
2019052136001.34
20190522-13357.1
2019052534533.23
201905263294.711
2019052722346.02
201905289280.91
201905297714.698

 

It cant be down to my filters, the histogram has been working fine for all other months.

Filters.PNG

 

anybody know why?

1 ACCEPTED SOLUTION
TeigeGao
Solution Sage
Solution Sage

Hi @shivenra ,

Based on my test, it works normally on my machine, I would suggest you upgrading PowerBI desktop and this visual to the latest version.

Snipaste_2019-04-19_13-55-09.png

Best Regards,

Teige

View solution in original post

4 REPLIES 4
TeigeGao
Solution Sage
Solution Sage

Hi @shivenra ,

Based on my test, it works normally on my machine, I would suggest you upgrading PowerBI desktop and this visual to the latest version.

Snipaste_2019-04-19_13-55-09.png

Best Regards,

Teige

parry2k
Super User
Super User

@shivenra seems like last value on your x-axis 278 is the value you are saying is missing.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hi, yes you are correct, as you can see it causes the x axis to populate that far, but doesnt populate the frequency of 1.

@shivenra what you use for frequency?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors