Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a Stacked Column visual with 8 columns( 1 db column with 8 different values). I would like merge 2 columns (or more) so that I would end up for 4 columns showing on my visual. Each of the 2 columns would have their values added together. I have tried to "Group" them together but all that does it make them the same color on the visual. And they are still separate columns. I would like their values to be calculated together and show as 1 column on the visual. So I would end up with 4 columns.
For example, state 1 + state 2 would be a new column called "Initial Entry"
state 3 + state 4 would be a new column called "External Processing, Govt"
state 5 + state 6 would be a new column called "External Processing, Agency"
etc.
I feel like I have seen this done in a video but now can't find it.
Thanks in advance for your input.
Scott
Solved! Go to Solution.
As you can see below I have made a chart based on the grouping, you need to add the grouping on the States and then add the count/sum based on the values of each state please check the print below.
Any additional question please tell me.
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @wskallmeyer,
Using Group works, however since you only have one colum that is calculation the several columns, and different attributes the colour is all the same, you must chose in the Visual option the Data Colors and then Show All, that will allowed you to make a different colour for each one.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis is what I had in mind. Take the 2 left columns and have them show as 1 column on the visual. The total would then be ~44. Adding their values in the process. And the same all the way across the chart. Grouping only seems to make their colors the same. That is not what I need.
Thanks!
As you can see below I have made a chart based on the grouping, you need to add the grouping on the States and then add the count/sum based on the values of each state please check the print below.
Any additional question please tell me.
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |