Forum Discussion
Histogram missing values
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
3 Replies
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