Home › Forums › Power Pivot › Blank column on a PIVOTTABLE Tagged: dax; pivot table This topic contains 0 replies, has 1 voice, and was last updated by sjhc1177 4 months, 3 weeks ago. Viewing 1 post (of 1 total) Author Posts September 4, 2019 at 8:49 pm #18159 sjhc1177Participant Started: 25Replies: 28Total: 53 Hi, I have a measure that works on fining the top 25 MODELS sold this month. I then use the same measure but modified for OH and again for INTRANSIT. My issue is the column in the PIVOT TABLE isn’t wide enough to show the name, but I dont want to widen it as the other items above and below fit in the column. What I need is a blank column in the pivot table to allow more data from the left column to appear. This is my current measure. TOP 25 MODEL UNITS SOLD:=VAR RankingContext = VALUES (‘tblInvMaster'[BRAND – MODEL]) VAR TopNumber = 25 RETURN CALCULATE ( [SALES UNITS SOLD], TOPN ( TopNumber, ALL( ‘tblInvMaster'[BRAND – MODEL]),[SALES UNITS SOLD] ), RankingContext ) Author Posts Viewing 1 post (of 1 total) The forum ‘Power Pivot’ is closed to new topics and replies.