cancel
Showing results for
Did you mean:
Frequent Visitor

## How to show two measures as stack bars and one measure as normal in one chart?

I have four measures A , B , C ,Total.I want to show A and B as one stack bar and C and Total as normal bar against month.

Is that possible via DAX? If yes, How?

5 REPLIES 5
Moderator

## Re: How to show two measures as stack bars and one measure as normal in one chart?

@NamanMittal,

I am not very clear about your desired chart. Could you please post a screenshot? Do all the measures share a single x-axis? If so, when you drag all  the measures into Stack bar chart, you will get the following chart:

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

## Re: How to show two measures as stack bars and one measure as normal in one chart?

Hi Lydia,

Thanks for a try. I have 4 measures A, B, C , D. I want stack bar graph to show A and B as one stacked bar and C and D for another stack bar and all these against my time  x-axis.

Moderator

## Re: How to show two measures as stack bars and one measure as normal in one chart?

@NamanMittal,

You may need to create two new measures, one to combine A and B, one to combine C and D. Please share sample data of your table and post a screenshot about your desired chart.

Regard,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

## Re: How to show two measures as stack bars and one measure as normal in one chart?

I also tried this. But I actually want to show the share of A & B in A-B stack also using diff colors. Similarly for C-D stack.

And as for data, I am having dummy currently, four measures A,B,C,D and month as dimension. If I use normal stack bar, It show all 4 measures in one for each month. (which is normal.).

But I want two group 2 measures in one bar as stack and 2 measures in another bar as stack , for each month.

Moderator

## Re: How to show two measures as stack bars and one measure as normal in one chart?

@NamanMittal,

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors