Histogram missing values

[Anonymous]

Hi All,

I'd like to create a histogram for one column (revenue), which shows the count of values in every bins with a fixed bin number. I also would like to add a slicer of this column, and when I use this filter, I except the histogram chart to recalculate istelf with the fixed number bins based on the counts with the filtered values. 

When I use the column chart it doesn't recalculate the bins after using the filter, it shows the 'original' bins with the filtered range.

The histogram chart somehow doesn't show me bins which is bigger than a value (10.164), but there are many records. But at least it recalculate the bins 🙂

Please find the pbix file here: https://drive.google.com/file/d/1OV1jb5X4yu7OFkSmdA1WLbSPKgXf-uhm/view?usp=sharing

Thanks your answers in advance!

BR,

Aron

[Anonymous]

Could somebody help me?

[Anonymous]

Hi  @Anonymous ,

It is not very clear what you mean, whether you can express the result you want in the form of pictures, we can better help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello Liu,

my goal is to have fixed number of bins (let's say 25) on the chart when I use the filter. So when I set it to

• 1-5000 is working perfectly, I have 25 bins
• 1-10 000 still working perfectly
• 1-15 000 doesnt work, I have 25 bins but plenty of values which bigger than the last bin (9.757..10.164) is missing

BR,

Aron