Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Do you know why the milestones colors and shapes are not consistent when a slicer is added?
So when no project is selected, Milestones from Goals category are dark blue and round, Risks milestones are dark pink and square and Milestones category has milestones that are dark purple and purple and the shape is rhombus. If I pick a project from the slicer this changes:
Why is that? Why the color and the shape of the milestones change? Why aren't they consistent?
Thank you!
Hi @v-lid-msft
Not sure I understand. Are you suggesting to select every single value in the slicer and then choose the milestones colors? That would not work if there are hundreds of values in the slicers or if a new value is added to the slicer when data is refreshed.
My slicer is for projects and new projects can be added every month. There are too many projects and too many milestone types to choose the colors for every such combination.
Thank you
Hi @Anonymous ,
This workaround we provided in our previous only works when the project is constant and has limited amount. It seems like a issue of this chart because it does not update for nearly three years, we will report this issue but we cannot sure if it will be fixed becaused it is a custom visual. But if we get anything new, we will update here.
Best regards,
Thank you for looking into it.
Hopefully a solution will come in the near future.
Thank you for your response. Why does the milestone need to be formatted as a date? I would like to have it as a text. Because I have milestones categories that are shared across projects and they need to be consistent. If I change the milestone type in your project, the issue reproduces. ( I added a 2 new columns, one named Project, that it is not in the Gantt chart, but it is used in the slicer, and one named Legend that is basically a copy of column ID-L1 because I wanted the lines in the Gantt chart to be colored diferently. Also added some extra data - level C)
Below is a screenshot if nothing is selected in the slicer:
Notice that when Project 2 is selected the milestone color of level B changes from pink to default green. It is interesting that the milestones color of Level A remain the same.
Data used:
Hi @Anonymous ,
Thank you for your additional information, it is very helpful. Based on my test, it save the setting of milestone for every different value in slicer.
After we change the value in slicer and then change the setting in milestone, it shows the expected result (below visual)
Best regards,
Hi @Anonymous ,
Sorry for that, but we cannot reproduce this in our sample, Could you please check the color setting in the format of milestone , it should format as each datatime.
Best regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |