Create miscellaneous/other group using count below a threshold
I've got a Line and Stacked Column Chart (using this because of Pareto line). I used to create a measure "Count". Count = CALCULATE ( COUNTROWS ( Projects ), ALLSELECTED ( Projects ), VALUES ( Projects[Points] ) ) "Project[Points]" is the Shared axis and "Count" is the Column values. Now I want to use this measure and combine any calculated values below 3 into a miscellaneous/other group. So it would be removing "M" thru "g", and creating an "other", stacking them all together. I've been using power bi for about 2 months now. So the more steps explained the better. Thank you.Date slicer - Max period multi select not updating Stacked Column chart
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?
