Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Not be grouped by

Hey! I got a bar chart, x-axis is list of brands, y-axis measure. Looks like this: (can't show x-acis due to company agreement). I need a measure that will be an average value of y-axis measur...
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    Can you try a Line & Clustered chart, using the overall measure as seconday Y? I'll paste image for more clarity. My example is on profit margin %, but can be done for your overall SAT measure. I hope this helps..

    Measure for flat line:

    Profit Margin% ALL =
    var profit = CALCULATE(SUM(Data[Profit]),ALL(Data))
    var sales = CALCULATE(SUM(Data[Sales]),ALL(Data))
    return
    DIVIDE(profit,sales)
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous just add your measure as a constant line in the analytics tab of the visual formatting :

 


2022-05-09 21_46_30-Auto sign in click on Sign-in if button appears ... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The answer is correct, very cool. But I should use not constant line, but average line, thanks, I didn't know about these feature.