Forum Discussion
Filtering by histogram bins in Power BI
but I would like to add the option to click on Histogram bins and to have the rest of the report filtered for People[ID] that fall into each range.
There is no data model relationship. Clicking on a bin is not the same as filtering the bins. Add another measure filter to the people table visual
- PatriciaHare1232 years agoFrequent Visitor
The People table visual is functioning correctly. However, the interaction between the histogram and: 1) the area graph (Attendance by Year Month) and 2) the column chart (People and attendance rate per weekday is not working properly).
The main issue is assigning specific People IDs to the histogram bins and filtering the measures in the area graph and column chart to calculate data only for those IDs. For example, if I select the 40-60% bin and there is one person, both graphs will display data for that person, even if the attendance rate for certain months (area graph) or weekdays (column chart) falls below 40% or above 60%.