Top N & Bottom N at the same visual including hierarchies
Hello, I have the below DAX Measure "FilterMeasure 3" added as filter in the visual which dynamically returns me the top 6 & bottom 2 "HRCHY_LVL_7" based on another measure "vs. Comparison Net Sales". FilterMeasure 3 = VAR CurrentBrand = SELECTEDVALUE ( 'Org Hierarchy Levels'[HRCHY_LVL_7] ) VAR T1 = ADDCOLUMNS ( ALLSELECTED ( 'Org Hierarchy Levels'[HRCHY_LVL_7] ), "@PYSales", [vs. Comparison Net Sales] ) VAR Top6 = TOPN ( 6, T1, [@PYSales] ) VAR Bottom2 = TOPN ( 2, T1, [@PYSales], ASC ) VAR T2 = SELECTCOLUMNS ( UNION ( Top6, Bottom2 ), "@Brand", [HRCHY_LVL_7] ) RETURN IF ( CurrentBrand IN T2, 1 ) The measure works fine, however I would like to give the option to end users to drill down more on hierarchy but I would like to always them to see the top 6 & bottom 2 based on the level they are. So my visual should be having the below on Y axis Unfortunately, the measure is not working with multiple data on Y Axis or it doesn`t give me for all levels the top 6 & bottom 2. Can you please propose an idea how to resolve this? Thank you very much in advance.
Waterfall chart with Top N / Bottom N sales based on slicer
Dear PowerBI Community, Despite having checked multiple threads on applicable DAX formula’s I can’t seem to find the correct solution for what I’m searching for. I would greatly appreciate it if someone could help me. For a data source, I have a single dataset of customer names, time periods and sales values. I want to setup a waterfall chart whereby between the totals, I want to show the top-5 gainers in sales, top-5 declines in sales and have the sales change of all other customers grouped together in ‘Others’. I verified that this can only be achieved using DAX formulas (i.e. not with just visualisation options). The thing that complicates this is that I have a slicer whereby the user can select any (2 or more) time periods, so the DAX formula needs to be dynamic to accommodate any combination of time periods. Would appreciate any DAX help.
