Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
selinozdemir
Regular Visitor

New column/parameter to distinguish

Hi everyone,

I want to draw a stacked column chart like this

ingekran.PNG

But my data is not suitable for this. First table is a sample from my data. 

ingtabloasıl.PNG

 

Above is the table that i want to create. I think i can draw the graph if i can create a table like this:

istenentabloing.PNG

I'm a beginner in PowerBI so I'm really confused. Are there any DAX or M codes or any other method for creating a column like that? Or any other method to draw the graph? Thanks for your support 🙂

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@selinozdemir , 1 .Unpivot all 4 column other then ID

2. Split the column by delimiter into 2 columns, so blue/ white, man/women separate out (The format you need a copy of the column before you split, I do not prefer that)

3. Pivot again with complete column you kept as backup

 

https://radacad.com/pivot-and-unpivot-with-power-bi

 

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@selinozdemir , 1 .Unpivot all 4 column other then ID

2. Split the column by delimiter into 2 columns, so blue/ white, man/women separate out (The format you need a copy of the column before you split, I do not prefer that)

3. Pivot again with complete column you kept as backup

 

https://radacad.com/pivot-and-unpivot-with-power-bi

 

Thank you so much 😊

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.