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

5 Replies

  • 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