Forum Discussion
Power BI
The standard date axis does this already for you. Have you considered using that?
Note that weeks are incompatible with pretty much everything else. You will need to have a static calendar table (ideally externally sourced) that clearly identifies the week number in your year and/or quarter.
do you know how to make sure both day got red color instead of one only?
because my intention to create a table where it shows red color if there is pending, or alt_hrs >slt_hrs. And it will show blue color if there is a test that got no pending, and its alt_hrs<slt_hrs.
Because currently my table only shows the result of red color based on end_time only.
I want the table if the test last for 2 days, it will show red color on both days instead on the end time day.