Forum Discussion
conditionally color data
Hello World !
on a simple column chart with on the x-axis the date and on the y-axis some measure,
i would like to be able to give a specific color for week-ends,
another for holidays, another for special days...
the model is simple, a fact table related to a date dimension containing the information about those days
(a column with 1 for week end, 2 for holyday, 3 special event... )
is there a way to do that ? if not, some other solution to be able to visualize that information ?
Thank you for the help
You can look at using the DateAttribute field as a legend entry. You can then use the visual 'Formatting' menu (the paintbrush icon under the Visuals pane) to change the data colors of your legend entries.
Only one field is allowed for the legend field well. You may be trying to pack too much information into a single visual. Could you provide a small table visual alongside your current chart listing the dates in context and what their type is? Slicing to e.g. a month or a week would filter that table down. Clicking on a specific date in the existing chart would give you just that date's attributes in the table.
This chart + detail table is an idiom I use pretty frequently. Visuals are exceptional for spotting trends and relative proportions, and can hold an incredible density of data if used properly. At a certain point, though, information density becomes a negative.
This is all very subjective, but I hope these thoughts help you in designing effective reports for your organization. I realize I've not really given a self-contained satisfying answer here, and for that I apologize.
5 Replies
You can look at using the DateAttribute field as a legend entry. You can then use the visual 'Formatting' menu (the paintbrush icon under the Visuals pane) to change the data colors of your legend entries.
Thank you for your answer, it works well but i have another problem now, i already had a dimension attribute (from another dimension i didn't talk about) in the legend entry, it's not possible to had a second one ?
Only one field is allowed for the legend field well. You may be trying to pack too much information into a single visual. Could you provide a small table visual alongside your current chart listing the dates in context and what their type is? Slicing to e.g. a month or a week would filter that table down. Clicking on a specific date in the existing chart would give you just that date's attributes in the table.
This chart + detail table is an idiom I use pretty frequently. Visuals are exceptional for spotting trends and relative proportions, and can hold an incredible density of data if used properly. At a certain point, though, information density becomes a negative.
This is all very subjective, but I hope these thoughts help you in designing effective reports for your organization. I realize I've not really given a self-contained satisfying answer here, and for that I apologize.
