Forum Discussion
Filtering by histogram bins in Power BI
Hi Everyone, In Power BI I have created a histogram that shows Number of People per Attendance Rate. To do so I have created additional table that defines the ranges for the histogram, which lo...
lbendlin
Super User
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- I have prepared the Sample Data and report here: Sample.pbix.There are 3 key visuals:1. histogram,2. attendance by year month area which works fine when not filtered by histogram,3. people and attendance rate by weekday column chart which works fine when not filtered by histogram.Basically, I would like to add the possibility to filter the report by the histogram and:1. have the area graph per year month to only calculate the Attendance rate over time for people that fall into chosen bin for the selected months (even if in certain months in the selected period it is above/below the chosen range),2. have the column chart with number of people per weekday calculate correctly number of people (now, when filtered with histogram, the measure calculates correctly the total number of people per filtered months, but shows incorrect split per weekday as per below (total is correct, but per day not):
I hope it makes sense.
