How to distinct column Row in Maq Gantt Chart

[her]

Hi all,

how to distinct column row in MAQ Gantt Chart Visualization..

repeated rows as to distinct 

if anyone find the solution  please let me know 

thanks and regards 

herwin

[MAQSupport]

Hello @her ,

We tested the visual with your dataset and observed the following:

Currently, three rows are displayed for Change Readiness Framework as there are 3 distinct values in ‘Activity’ column for this category.

To have distinct column row for Initiative ‘Change Readiness Framework’, you can remove the ‘Activity’ column dragged in Category.

On removing ‘Activity’ column, there will be a single distinct row as shown below:

Please feel free to contact us at support@maqsoftware.com for any issues.

[her]

Hi @MAQSupport  

Thanks for your response but initiative name must distinct only at the same time only one initiative name  show..

here Agile training program  two is there but we want to show one that is my requirement.

thanks and regards

Herwin

[Anonymous]

@her - Does it work if you remove Activities?

[her]

hi @Anonymous  

its not working removed after Activity...

thanks regards

herwin

[v-lili6-msft]

hi, @her 

I think there must be other fields could not be aggregated in this chart.

So the best way to check it is:

Copy this visual and then change the duplicate visual to table visual

Now use a slicer to filter the Initiatives is "change Readiness Framework" to check which field isn't aggregated.

For example:

This is my simple example

Then I COPY it and then change it to table visual

Now we find that there is a field "Milestone" could not be aggregated which leads to this problem.

Then we remove field "Milestone" for Maq Gantt Chart and it meets your requirement.

If you still have the problem, please share a simple sample pbix file for us to have a test.

Best Regards,

Lin

[her]

Hi @v-lili6-msft ,

Thanks for your response. However as per our requirement, we need all the fields specified in our example in the report.

Thanks,

Herwin

[v-lili6-msft]

hi, @her 

Because there are one or more fields couldn't be aggregated. so they will be shown by multiple lines.

Unless you remove it by the way i have provided above.

Best Regards,

Lin