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,
I have 2 tables:
1) Table with a list of roles and employee number attached to them.
2) Chart with dates
Every person is attached to a different date (they are taken from excel- there is a difference between specific days but it is not the case)
Difficulty is:
I want this first graph to show on a default nr of employee only for the actual month (March in this case)
But it is summing up all the employees for all the months, unless I click particular month.
I was thinking about adding to this visual a filter with date, but then interaction with the date graph no longer works.
Do you have any idea how to do it?
Solved! Go to Solution.
@Anonymous
please try to create a measure
Measure =
VAR maxdate=max('Table'[Date])
return CALCULATE(count('Table'[First&Last]),FILTER('Table',YEAR('Table'[Date])=year(maxdate)&&MONTH('Table'[Date])=month(maxdate)))
Below is the attachment
Proud to be a Super User!
@Anonymous
please try to create a measure
Measure =
VAR maxdate=max('Table'[Date])
return CALCULATE(count('Table'[First&Last]),FILTER('Table',YEAR('Table'[Date])=year(maxdate)&&MONTH('Table'[Date])=month(maxdate)))
Below is the attachment
Proud to be a Super User!
Thanks sooo much !
you are welcome
Proud to be a Super User!
@Anonymous Well you could create a measure that returns 1 for only the most current month and 0 otherwise and filter on that. But if I understand your second question, you would want a way for users to disable this, correct? Perhaps you could use something like HASONEVALUE to check if the user has selected something in the date graph and if so, return 1. If a check confirms that nothing has been selected, then you could implement returning 1 for the current month only and 0 otherwise.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |