Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 8 | |
| 8 |