Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 looks like this:
HistogramBins:
IDBinMaxMin
1 | 0-20% | 0.2 | 0 |
2 | 20-40% | 0.4 | 0.2 |
3 | 40-60% | 0.6 | 0.4 |
4 | 60-80% | 0.8 | 0.6 |
5 | 80-100% | 1.01 | 0.8 |
Then I created the measure that would count how many people falls into each range by Attendance rate:
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
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%.
Please 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-...
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/1447...
I hope it makes sense.
User | Count |
---|---|
25 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
40 | |
28 | |
28 | |
22 | |
21 |