Power BI

[Anonymous]

I'm trying to create a dynamic date column in Power BI that can display data at different granularities (days, weeks, months) based on a user-selected option. I've created a date table and a parameter to control the granularity.

Example:

If the user selects "Day", the column should display individual dates. If the user selects "Week", the column should display the start date of each week. If the user selects "Month", the column should display the first day of each month. this is the image for you guys understand.

[lbendlin]

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.

[Anonymous]

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.