Forum Discussion
Grouping data for a visual
I have 2 tables items sales and a second that has item cost
both linked to master inventory table
I have a measure that calculates my GP% however i want to group my GP's as per below
thats where this formula i found on the forum comes in
Please assist on a fix or possible alternative
original formula from a reply by Greg_Deckler on different post
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Good day
Thank you for your response
As per above this a sample of a visual i want to see
With that i also want to drill down each slice to see the items in that GP% range
below is my 3 sample data sources
Item sales
Barcode Product Description Unit Price FRBR8 FRANGOSA BRAAI PACK 8X800G FZN 36.9 3C5 CHUBBY CHICK IQF 3X5KG 29.75 C26 CHUBBY 6X2KG IQF 29.8 RHF Rainbow Head And Feet 10x1kg 12.5 DCD10 DS - FRESH DRUMSTICK 10Kg 45.5 3R5MP RB IQF MIX PORTIONS 3X5KG 30.5 Last GRV Cost
Item Code Item Description Last Invoice Cost 3C5 CHUBBY CHICK IQF 3X5KG 28.03 3R5MP RB IQF MIX PORTIONS 3X5KG 32.87 C26 CHUBBY 6X2KG IQF 28.03 DCD10 DS - FRESH DRUMSTICK 10Kg 44 FRBR8 FRANGOSA BRAAI PACK 8X800G FZN 28.5 RHF Rainbow Head And Feet 10x1kg 9.98 Master stock data
Item Code Item Description RHF Rainbow Head And Feet 10x1kg 3C5 CHUBBY CHICK IQF 3X5KG C26 CHUBBY 6X2KG IQF FRBR8 FRANGOSA BRAAI PACK 8X800G FZN 3R5MP RB IQF MIX PORTIONS 3X5KG DCD10 DS - FRESH DRUMSTICK 10Kg Thank you
