cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Stacked column chart with text as data labels

Hi, I want to make a visual to display my "project pipeline". I have a list of projects with their current phase, and I want to make a visual to show the pipeline. What I have in mind is a stacked column chart with phase on the x-axis, count of project title on the y-axis and the project title as a data label. I am able to create the stacked column chart, but the data label is linked to the count of project title, so each box in the column is filled with a 1. I want this 1 to be the project title. Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Stacked column chart with text as data labels

@oslosa ,

 

You may use "Group by" feature in query editor(the transform panel) to achieve the count of  each group, then apply the modification and drag the new column to the legend field in the stack bar visual.

 

Or create a calculate column using dax expression.

Group Legend =
CALCULATE (
    COUNTROWS ( Table ),
    FILTER ( Table, Table[Category] = EARLIER ( Table[Category] ) )
)

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Helper I
Helper I

Re: Stacked column chart with text as data labels

Hi !

Please try using Gannt Chat visual for this purpose.

Regards,

Highlighted
Community Support
Community Support

Re: Stacked column chart with text as data labels

@oslosa ,

 

You may use "Group by" feature in query editor(the transform panel) to achieve the count of  each group, then apply the modification and drag the new column to the legend field in the stack bar visual.

 

Or create a calculate column using dax expression.

Group Legend =
CALCULATE (
    COUNTROWS ( Table ),
    FILTER ( Table, Table[Category] = EARLIER ( Table[Category] ) )
)

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors