cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Avivek
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

Avivek_0-1597440844606.png

 

 

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.

1 REPLY 1
lbendlin
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

Announcements
Carousel_PBI_Wave1

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.