SOLVED

Pivot Table Number Grouping

%3CLINGO-SUB%20id%3D%22lingo-sub-2577930%22%20slang%3D%22en-US%22%3EPivot%20Table%20Number%20Grouping%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2577930%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3ECurrently%20I%20am%20able%20to%20group%20numbers%20in%20Pivot%20table%20without%200%20as%20separate%20row.%20Is%20it%20possible%20to%20have%20Zero%20as%20separate%20line%20item%3F%20I%20am%20sharing%20Pic%20of%20both.%20What%20I%20have%20in%20Excel%20and%20What%20I%20want%20in%20Excel%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2577930%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2579359%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Number%20Grouping%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2579359%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1110634%22%20target%3D%22_blank%22%3E%40npameh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20that's%20only%20with%20data%20model%20creating%20helper%20table%20with%20ranges%20and%20proper%20measures.%20Like%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.burningsuit.co.uk%2Fblog%2F2018%2F06%2Fdax-how-to-group-measures-into-numeric-ranges%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EDAX%3A%20How%20To%20Group%20Measures%20Into%20Numeric%20Ranges%20%7C%20Burningsuit%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2580204%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Number%20Grouping%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580204%22%20slang%3D%22en-US%22%3EOkay.%20Thanks%3C%2FLINGO-BODY%3E
New Contributor

Hi,

Currently I am able to group numbers in Pivot table without 0 as separate row. Is it possible to have Zero as separate line item? I am sharing Pic of both. What I have in Excel and What I want in Excel

 

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@npameh 

Perhaps that's only with data model creating helper table with ranges and proper measures. Like here DAX: How To Group Measures Into Numeric Ranges | Burningsuit

Okay. Thanks