Forum Discussion

NamanMittal's avatar
NamanMittal
Frequent Visitor
8 years ago

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?
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

NamanMittal's avatar
NamanMittal
Frequent Visitor
8 years ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

    • NamanMittal's avatar
      NamanMittal
      Frequent Visitor
      8 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        NamanMittal,

        I am not very clear about your expected chart. Please post a screenshot about your desired result. Sample data is also appreciated.

        Regards,
        Lydia