Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
@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
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.
@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
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.
@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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |