Forum Discussion

errepinna's avatar
errepinna
Icon for Helper I rankHelper I
5 years ago
Solved

Grouping histogram bars

Hello everyone,   I'm trying to do something simple. I got different values of the same kind referring to the same entities, and I want to group them in an histogram together.   I made an excel f...
Need Help
errepinna's avatar
errepinna
Icon for Helper I rankHelper I
5 years ago

I've already made a common table for the "location". Yet if I try to put both measures on values, it just piles them up in a single bar.

 

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi  errepinna ,

     

    Can you provide a sample .pbix file for test?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi  errepinna ,

         

        Modify your measures as below:

        %impactAoverTotA = 
//SUM('A type sale'[A value])/CALCULATE(SUM('A type sale'[A value]), REMOVEFILTERS('type'[Type]))
var _sumA=CALCULATE(SUM('A type sale'[A value]),FILTER(ALL('A type sale'),'A type sale'[Location Code]=MAX('location'[Location Code])&&'A type sale'[Type]=MAX('type'[Type])))
var _sumtotal=SUMX(ALL('A type sale'),'A type sale'[A value])
Return
DIVIDE(_sumA,_sumtotal)
        %impactBoverTotB = 
//SUM('B type sale'[B Value])/CALCULATE(SUM('B type sale'[B Value]), REMOVEFILTERS('type'[Type]))
var _sumB=CALCULATE(SUM('B type sale'[B Value]),FILTER(ALL('B type sale'),'B type sale'[Location Code]=MAX('location'[Location Code])&&'B type sale'[Type]=MAX('type'[Type])))
var _sumtotal=SUMX(ALL('B type sale'),'B type sale'[B Value])
Return
DIVIDE(_sumB,_sumtotal)

        Then turn off "Concatenate labels" under X axis:

        And you will see:

         

        For the related .pbix file,pls see attached.

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!