Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Need to show individual columns as a single column

I have a requirement for giving the report on the system's and one of the requirement is to show the tag, below is the image of what we need




As we can see M1,M2, M3 is the usage month. And the numbers on the right is the age group by month wise(difference between placement date and today's date)  for which i have already created the measures.

Eg.In M1 100 means 100 counts of tags have been used in age group 1, 150 used in age group 2 and 180 used in age group 3 and so on.

The usage M1, M2,M3....M6 are all data's already present as individual columns in table, so when I create the visual adding individual columns in the axis it obviously gives in the form of hierarchy and I can see only one at a time.

So I tried to create another column trying to have M1, M2, M3,M4,M5,M6 in one single column as 


Capture (1).PNG


Column = IF('Active Front Loaders'[M1],"M1", IF('Active Front Loaders'[M2],"M2", IF('Active Front Loaders'[M3],"M3",IF('Active Front Loaders'[M4],"M4"))))

But that gives me only M1 and not the other usage month.



And if this I try to see in the bar chart it looks like this


Capture (3).PNG


This is the closest to what we require however the column creayed doesn't seem to work, can anyone suggest me cow the column can be created for this.Probably then this may work. Any other suggestion is also appreciated.

Super User
Super User

Easiest would be to unpivot your data in Power Query  into a form like


Month  Group   Value


Show a sample of your source data and we can help you with the transform.

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.