How I mix two graphs

[bee_kissme]

I set seperate data two groups but I want 3 bar in a graph

Now

Want one graph right pie and line !!!

[bee_kissme]

Dear @SqlJason

I - Create clustered column chart

II - Create disconnected table 

[SqlJason]

I think I got the issue. In the second approach, use only the TestAll measure on the values, and the GenderAll[Gender] on the axis. I think you kept all 4 measures on values and nothing on axis.

[ElliotP]

If you need to use a clustered column to visualise your data it might not visualise to demonstrate the meaning you want. In the sense that for example, if on the same clustered bar column you want to show "All", "Male" and "Female"; the % value for "All" won't show 100% but rather whichever proportion of the new total sum under consideration.

Using a vertical bar chart and the legend feature could be a good idea. Or creating your own percentage measures (could even use the quick calc in powerbi) might be a nicer and cleaner solution.

A slicer is always a good idea (incredibly useful), plus something I really started to appreciate recently was how if you have two graphs next to each other for example in a report (for example's sake), then if you were to click the "female" component it will transform the graph next to it to only show the female data.

Depending upon what your purpose or aim with the data visualisation is; it might be just as easy to simply visualise all, Legend it by Gender as so "Male" & "Female" show their % amounts. Just some ideas, I feel @SqlJason is on the right path/might already have the solution.

[SqlJason]

There are no perfect solutions for this, but I can give you 2 workarounds:-

I - Create clustered column chart

1) Create the below 3 measures (change table names appropriately)

MalePct = CALCULATE(SUM('Fact'[Pct]), 'Fact'[Gender]="Male")

FemalePct = CALCULATE(SUM('Fact'[Pct]), 'Fact'[Gender]="Female")

AllPct = CALCULATE(SUM('Fact'[Pct]), 'Fact'[Gender]="Male" || 'Fact'[Gender]="Female")

2) Create clustered column chart with just these 3 measures. You will get all three bars but they will not have the spacing.

II - Create disconnected table 

1) Create a disconnected table GenderAll with 3 values for Gender - Male, Female, All

2) Now create a measure 

PctWithAll = SUMX(VALUES(GenderAll[Gender]), SWITCH(GenderAll[Gender], "Male", [MalePct], "Female", [FemalePct], "All", [AllPct]))

3) Now create your regular column chart and it show as you want.

[bee_kissme]

Dear @SqlJason

I create following as you but it is not the spacing.

MalePct = CALCULATE(COUNTA(dim_personal[sex]), dim_tec_personal[sex]="male")

FemalePct = CALCULATE(COUNTA(dim_personal[sex]), dim_tec_personal[sex]="female")

AllPct = CALCULATE(COUNTA(dim_personal[sex]), dim_personal[sex]="male" || dim_personal[sex]="female")

TestAll = SUMX(VALUES(dim_personal[sex]), SWITCH(dim_personal[sex], "male", [MalePct], "female", [FemalePct], "all", [AllPct]))

I - Create clustered column chart

1) Create the below 3 measures (change table names appropriately)

2) Create clustered column chart with just these 3 measures. You will get all three bars but they will not have the spacing.

II - Create disconnected table 

1) Create a disconnected table GenderAll with 3 values for Gender - Male, Female, All

2) Now create a measure 

3) Now create your regular column chart and it show as you want.

[SqlJason]

Can you put an image of your chart as well as an image of your model?

In the image of the chart, please make sure that yo are showing what is on X and Y axis.