The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table in Power BI that displays data based on the selected month from the drop-down filter. However, when I select a specific month, the table shows data from the previous or upcoming month as well, in addition to the selected month. This issue is causing a discrepancy in my data analysis.
Picture of the table showing data from the previous or upcoming month:
I have checked the data source and confirmed that there are no data errors. I have also checked the filters in the table and confirmed that they are set up correctly. I am not sure what else could be causing this issue.
Can anyone help me troubleshoot this issue? Any suggestions or guidance would be greatly appreciated.
Thank you in advance for your help!
I use a merged table of Datemin and Datemax as shown below:
I also use a Power Query Formula to calculate the 'Reception date" Column:
Processing time = [DATE REPONSE]-[DATE RECEPTION]
@Anonymous , Ideally you should join truncated response and reception dates to date table a and use date table for analysis. One join will be inactive and you can userelationship to activate that
response dt = datevalue(Table[response date])
Refer to how to deal with two-dates
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
I'm pretty much new to Power Bi can you please elaborate more on this ?