User Profile
Rockz
Helper I
Joined 2 years ago
User Widgets
Contributions
Incremental refresh for larger datasets
Dear champions!, I need an urgent help and good advice from you!! In my case, within one of my Mart, I have data spanning from January 1, 2023, to December 31, 2025. I have considered this timeframe as the range start (January 1, 2023) and range end (December 31, 2025) period. Subsequently, I selected a table containing a large volume of data and applied relevant filters. Initially, the impact date column in this table was in text format, so I converted it into a date-time column. I then applied the range start range end parameter filters to this column. After making these adjustments, I loaded the data into Power BI Desktop. Within Power BI, I selected the table where I wanted to implement incremental refresh. By right-clicking on the table, I accessed the incremental refresh settings, enabled them, and specified 36 months for archived data and 2 months for incremental refresh data. After applying these changes, I published the dataset to the service. However, the process encountered timeout issues. Could you kindly advise on how I might resolve these issues and successfully implement the incremental refresh? and my data is from sql server database. This is my M query for that table. please explain me step by step clearly! Thanks in advance!Solved2.8KViews0likes6CommentsHow to maintain pie chart legend colors consistent.
Dear Champions, I'm using a Pie chart visual in power Bi and under legends Am using category calculated column to display the sales closed or open in X days and this X will be dynamic as the value changes at back end this X will also change in category. so while changing the color of these categories is also changing. how to keep these categories colors static. this is the category calculated columnCategory= VAR X = MAX('Table'[Value]) VAR Achieve mins = X * 3 * 60 RETURN IF( [Status] IN {"Closed", "Completed"} && [ProcessingTime_Mins] <= Achieve mins, "Closed within " & X & " days", IF( [Status] IN {"Closed", "Completed"} && [ProcessingTime_Mins] > Achieve mins, "Closed more than " & X & " days", IF( [Status] IN {"Started", "New"} && [ProcessingTime_Mins] <= Achieve mins, "Open within " & X & " days", IF( [Status] IN {"Started", "New"} && [ProcessingTime_Mins] >Achieve mins, "Open more than " & X & " days", "Unknown" ) ) ) ) Thanks in advance.Solved740Views2likes2CommentsHow to get Last three working days data when user open the report.
Dear Champions, I need a small help from you. Iam trying to implemet a requriement where the whole report will show Working days and hours data. So in this report am using a date range slicer where user can choose dates by self. when user open the report the data should show last three working days data and user should also be able to move the dates by his choice. How can I achieve this? Thanks for your help in advance!.466Views0likes2CommentsRe: How to Pie chart can be interacted with table visual and stacked Colum chart without using legends
Dear Thanks for your quick response, So In the below Piechart when I click on any of the measure value for example in below pie chart Iam using close within in the time so when I click on that measure then beside visual should also filter and give the result. This is the measure Iam using in Piechart values. Closed within the time = VAR X = [Selected Number of Days] VAR AllowedTime = X * 6 * 60 RETURN CALCULATE( COUNTROWS('XYZ_Table'), 'XYZ_Table''[status] IN {"Close", "Complete"} && 'XYZ_Table'[Processing Time] <= AllowedTime Hope you got my issue. and I have tried what amitchandak sugggested by using Group calculations but it is not working. Thank you.731Views0likes1CommentHow to Pie chart can be interacted with table visual and stacked Colum chart without using legends
Dear Champions, I need your help here am using a piechart where this pie chart to be interacted with table and bar chart visual. I'm not using legends here and using only values as measures. how can I achieve this ? and I have tried edit interactions as well but it didn't worked. Thanks in advance.Solved821Views0likes5CommentsDirect query mode logics
Dear champions, Can anyone please suggest me whether it is possible to use parameters in slicer to filter the data in direct query mode? Because am not am able to achieve it. and also one more thing could anyone please let us know how business hours logic works in direct query mode? thanks in. AdvanceSolved319Views0likes1CommentRe: How can we create business working hours and days in Direct query mode?
Dear, I'm getting this error again! Function 'CALCULATE' is not allowed as part of calculated column DAX expressions on DirectQuery models. Working Hours Between Dates = VAR startDate = DATEVALUE('Issue Query'[DateCreatedon]) VAR startTime = TIMEVALUE('Issue Query'[DateCreatedon]) VAR endDate = DATEVALUE('Issue Query'[DateClosedOn]) VAR endTime = TIMEVALUE('Issue Query'[DateClosedOn]) VAR firstFullDay = startDate + 1 VAR lastFullDay = endDate - 1 VAR inBetweenWorkingHours = IF ( firstFullDay > lastFullDay, 0, CALCULATE ( SUM (WorkingHoursTable[WorkingHours]), FILTER ( WorkingHoursTable, WorkingHoursTable[Date] >= firstFullDay && WorkingHoursTable[Date] <= lastFullDay && WorkingHoursTable[IsWorkingDay] = 1 ) ) ) VAR firstDayStart = CALCULATE( MAX(WorkingHoursTable[WorkstartTime]), FILTER( WorkingHoursTable, WorkingHoursTable[IsWorkingDay] = WEEKDAY(startDate, 2) ) ) VAR firstDayEnd = CALCULATE( MAX(WorkingHoursTable[WorkEndTime]), FILTER( WorkingHoursTable, WorkingHoursTable[IsWorkingDay] = WEEKDAY(startDate, 2) ) ) VAR lastDayStart = CALCULATE( MAX(WorkingHoursTable[WorkstartTime]), FILTER( WorkingHoursTable, WorkingHoursTable[IsWorkingDay] = WEEKDAY(endDate, 2) ) ) VAR lastDayEnd = CALCULATE( MAX(WorkingHoursTable[WorkEndTime]), FILTER( WorkingHoursTable, WorkingHoursTable[IsWorkingDay] = WEEKDAY(endDate, 2) ) ) VAR effectiveStartTime = IF(startTime < firstDayStart, firstDayStart, startTime) VAR effectiveEndTime = IF(endTime > lastDayEnd, lastDayEnd, endTime) RETURN IF( startDate = endDate, 24 * IF(effectiveEndTime > effectiveStartTime, effectiveEndTime - effectiveStartTime, 0), VAR firstDayWorkingHour = 24 * IF( startTime > firstDayEnd, 0, firstDayEnd - effectiveStartTime ) VAR lastDayWorkingHour = 24 * IF( endTime < lastDayStart, 0, effectiveEndTime - lastDayStart ) RETURN firstDayWorkingHour + lastDayWorkingHour + inBetweenWorkingHours ) Thanks in advance!.696Views0likes1CommentHow to Implement User-Defined Input Parameter for Target Processing Time in Power BI direct query
subject : How to Implement User-Defined Input Parameter for Target Processing Time in Power BI direct query mode Hello Power BI Community, I need help creating a user-defined input parameter in Power BI to calculate target processing times for issues. Users should be able to set a value X (in days), which will be used to determine if issues meet the target processing time. ### Key Requirements: *User Input Parameter:* - Users set X via a slicer. - TargetValue = X * 8.5 * 60 (minutes). *Calculations:* - Calculate processing time in minutes. - Determine if processing time meets the target: DAX AchieveTarget = IF([TotalProcessingTime] <= [TargetValue], "Achieve", "Not Achieve") *Working Hours:* - Exclude non-working hours (Monday to Friday, 8:00 AM to 4:30 PM) in processing time calculations. ### Example Data: | Status | Issue No | Issue Created Date | Close Date | Processing Time | Achieve Target | |--------|-----------|----------------------|---------------------|--------------------------|----------------| | Closed | 12345 | 2024-03-11 09:00 | 2024-03-12 12:00 | 1020 mins | Achieve | | Open | 12346 | 2024-03-11 11:00 | - | 1440 mins (up to now) | Not Achieve | ### Need Help With: *Creating a parameter for user input.* *Using this parameter in DAX calculations.* *Accurately calculating processing time considering only working hours.* *Dynamically updating visuals based on the user-defined parameter.* Thank you for your assistance!Solved471Views0likes1CommentRe: How can we create business working hours and days in Direct query mode?
Dear , Thanks for your quick response. But while using this i'm getting this error DAX comparison operations do not support comparing values of type True/False with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values. and I need to use true/false condition for working hours table. This is the measure im using for working working hours table. WorkingHoursTable = ADDCOLUMNS ( CALENDAR (DATE(2020, 1, 1), DATE(2030, 12, 31)), "IsWorkingDay", IF (WEEKDAY([Date], 2) < 6, 1,0) ) Thank you.764Views0likes3Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.