The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
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.
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.
Hello Greg,
Thank you for your advice, i finally found something that suits my needs, here's a screenshot:
@oxbord, that is a really nice presentation. Very clean and clear communication. Thanks for sharing with us.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
244 | |
128 | |
119 | |
82 | |
78 |