![]() ![]() We should create another measure called “TodayLine” for this. Otherwise, it will use “|” in a cell to imitate a line by repeating it in each row. ![]() If they are, it will fill that cell with a⭐. Therefore, the code will first check if the start and end dates are the same for a process. We also would like to show a line for Today’s date and use an icon to illustrate milestones. BetweenDates = VAR beginning = min ( Sheet1 ) VAR finish = max ( Sheet1 ) VAR duration = max ( Sheet1 ) VAR colorVar = 0 RETURN SWITCH ( TRUE(), AND ( MAX ( 'Calendar' ) >= beginning, MIN ( 'Calendar' ) 0,1 ) To do that, you need to create a new measure in your schedule data. If the date range (start and end of the project) coincides with the calendar dates we created, the cell should have 1, otherwise 0. We need to write a function that looks at the process dates and adds 0 or 1 based on the date range. The next thing is to add some values to these date columns we created. When you populate the columns with dates, your visual will fail, and you will see a message saying “Can’t display the visual” since there are no values associated with these dates that we created. If your calendar is created, you need to add the date variables to your columns of the matrix visual. You don’t have to add quarters, weeks, and/or days if you don’t need them in your schedule. ![]() Our dates will start from and go all the way to 2026. Here is the code we will use to create our calendar. Once your click “New Table”, PowerBI will let you write a DAX code starting with “Table =”. This will create a new empty table in your model. Click “New Table” in the top menu under “Calculations”. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |