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.
I have the following (simplified) stacked column chart which counts the number of issues per source:
Based on this (simplified) data:
I then apply a date slicer which allows multiple selections
The date slicer is joined in the model and works correctly by adjusting the number of issues if one month is selected at a time.
When multiple months are selected then it need only evaluate the most recent month which I have calculated with the following 2 measures:
MaxPeriod = CALCULATE ( MAX ( vw_DimDate[Month] ))
IsMaxPeriod = IF(NOT(ISBLANK([MaxPeriod])), IF( MAX ( vw_PBI_MR_IssuesByAct[Period] ) = [MaxPeriod], 1, 0 ))
Confirmed to be working with a table visual:
If I then apply this filter, the table visual shows the correct count of 39 for the period of 202006
The problem is that the stacked bar chart does not-it shows 70 issues rather than 39 for 202006-any ideas on how to solve this?
Solved! Go to Solution.
You forgot to use ALLSELECTED in your MAX part.
I would think that your desired implementation will lead to bad UX. Meaning that users can select June and any other prior month but only June values should be shown? That is non-intuitive.
You forgot to use ALLSELECTED in your MAX part.
I would think that your desired implementation will lead to bad UX. Meaning that users can select June and any other prior month but only June values should be shown? That is non-intuitive.
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
50 | |
47 | |
16 | |
13 |