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.
Howto add visualization of weekends? Best would be to colorize weekend sections the line itself. But this method below would be helpful too.
Please refer to picture below:
Thank you!
@gendat,
If you use the ChrisHaas’s formula to create custom column, you would need to change the formula to the following:
if Date.DayOfWeekName([Date]) = "Saturday" then "Weekend" else if Date.DayOfWeekName([Date]) = "Sunday" then "Weekend" else "Weekday"
Alternatively, you can create a calculated column using DAX below. And you can create Line chart or column chart as shown in the following screenshots.
CheckWeekend = IF( OR(WEEKDAY(Table[Date])=1,WEEKDAY(Table[Date])=7),"Weekend","Weekday")
Regards,
Lydia Zhang
Add a column in Query Editor to check for weekends.
Click Add Column...Add Custom Column, and paste in the following:
if Date.NameOfDay([Date Column]) = "Saturday" then "Weekend" else if Date.NameOfDay([Date Column]) = "Sunday" then "Weekend" else "Weekday"
Then add that column as a legend to your line chart.
Or adding a bar like this, but coloriznig the line is prefereable. Thanks!
Colorizing the line is preferable, but this bar is ok too, how to do this?
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 |
---|---|
107 | |
93 | |
77 | |
64 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |