Clustered column chart help

[fansari16]

Hello BI community,

I am new to POwer BI & I am loving it so far. Recently I have encountered a problem. I am trying to compare results of two quarters ( from a survey).

When I draw two separate bar chart chart separately, the values of the bars are different from when I make a clustered chart.

I've attached the image of the chart which I want to achieve (I drew this in excel). I've also attached the data sets too. Please help!. Although the graph is similar in Power BI & Excel, the values are different. Data Set is attached here too. 

 

[stretcharm]

It looks like your using show as % of Grand Total. The total has changed by adding both Quarters which affects the figures.

Try creating  your own dax that calculates by Quarter. Something like this.

PerOfQuarter =
VAR QtrTotal =
    CALCULATE ( SUM ( Rating[Count] ), ALLEXCEPT ( Rating, Rating[Quarter] ) )
RETURN
    SUM ( Rating[Count] ) / QtrTotal

[stretcharm · Accepted solution]

Using your sample document this Measure will give the correct percentages.

PerOfQuarter = 
VAR QtrTotal = 
    CALCULATE ( COUNT('Form Responses Q1 and Q2'[Timestamp]) , ALLEXCEPT ( 'Form Responses Q1 and Q2', 'Form Responses Q1 and Q2'[Quarter] ) )
RETURN
    COUNT('Form Responses Q1 and Q2'[Timestamp])  / QtrTotal

[fansari16]

@stretcharm You are a genious. I got it. Thank a lot. I deeply appreciate your help.

[stretcharm]

Hopefully you've got it working now.

Check out this list of PowerBI training links that will help you

https://community.powerbi.com/t5/Desktop/Good-Source-to-Learn-DAX/m-p/539642#M253384

[fansari16]

Thanks a lot @stretcharm. Really appreciate your help & expertise. Can you guide how & where to add this measure?

Unfortunately I am new to powerBI. Or can you share your PowerBI file so that I can see how you did that. That would be a huge help.