The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
32 | |
14 | |
11 | |
10 | |
9 |