Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello folks,
We have a table 'Submission' containing on which days a person submitted a record. We would like to show percentage range of the submission on a bar chart, based on slicers (of date range selected and county selected). 'County' won't change for a person.
1. Table: Submission
2. A date table is created in Power BI desktop:
3. One to many relationship on DateTable[Date] and Submission[Submission_date] has been defined in PBI desktop:
4. The calculation I did in table 'Submission':
1) a Measure to count how many submissions for each person during selected date range (in the slicer in step 2):
2) A measure to calculate the submission percentage (for example, if 003 submitted 6 times during 3/1/21 through 3/15/21, the percentage is 6 times/15 days = 40%.
5. Next I want to use a bar chart to present the percentage range, but 'Measure_range' can't be used in x-axis of a bar.
So I create a calculated column 'Column_Range', but the range is not right because it is calculate for each row instead of each id. The bar has 'Column_Range' in x-axis and 'count of Column_Range' in value. It shows '0-20%' only. It still changes with the selections in both slicers.
So, the question is, how can I make the column calculate for each ID instead of each row? If that is not possible, is there any other ways to achieve what I want to do?
Don't have an answer (maybe you can provide sample data in usable form?) but be aware that your SWITCH statement can be simplified, and also should be extended to cover situations over 100%
Thanks! Here is the data:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |