Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I am very new to Power BI and i have below requirement, can you please help me with this.
i have one table with Date, Sitename, region, sub region etc., fields.
In Power BI Report view i have one Sitename slicer and one date slicer type as relative, and few table visuals to show the respective data.
1. When ever user selects the Sitename from slicer, we need to get the max date data and the range to get this max date is previous week monday to till today.
2. Once we have the max date data from the range mentioned in first point, now if the user changes the dates range using date slicer (not changing the Site name slicer) we need to get the respective data of the selected range in date slicer.
Hope this is clear and let me know for any queries, please help me to get this done.
Thank you in advance.
HI Daniel,
unable to add sample data and power bi file FYR.
Note - when ever we are loading the report we are hiding the data using Hide measure and you can see the formula.
Now, In Power BI Report view i have one Sitename slicer and one date slicer type as relative, and few table visuals to show the respective data.
1. When ever user selects the Sitename from slicer, we need to get the max date data and the range to get this max date is previous week monday to till today i am able to get this information using this measure NOW()-7-WEEKDAY(NOW(),3)
2. Once we have the max date data from the range mentioned in first point, now if the user changes the dates range using date slicer (not changing the Site name slicer) we need to get the respective data of the selected range in date slicer.
Let me know for any other information.
Could please let me know how to add sample excel and power bi file to this conversion as i am not able to attach it over here.
Hi @Bhavyabujji,
You could upload your report to your OneDrive or Dropbox and send the link here, could you please post a desired result if possible?
Regards,
Daniel He
Hi Daniel,
Based on site name slicer selection, i am flitering the data of last week Monday to till today, if no data it should be NA and i am using below calucluated columns and doing visual level filters using RoundDate.
ANy update
Hi @Bhavyabujji,
From your description, it seemed if you have selected one item from the Sitename slicer, it do will effect the range data slicer, could you have tried change the interaction in your report?
Reference:https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
I still hope you could offer me a sample pbix if possible.
Regards,
Daniel He
Hi Daniel,
I had added the files in below link https://wipro365-my.sharepoint.com/personal/bpasu_wipro_com/_layouts/15/onedrive.aspx?id=%2Fpersonal...
with below formulas i am able to get data
Any update please we need this on high prioirty
Any updates please
Hi @Bhavyabujji,
Sorry, I could not have access to your file from your link:
Could you please upload your file to OneDrive or Dropbox and send the link here if possible?
Regards,
Daniel He
i have uploaded in OneDrive site only, can you please share the mail id so that i can share the file to your mail id
Hi @Bhavyabujji,
You could upload your report to your OneDrive and send the link to me via private message.
Regards,
Daniel He
Hi @Bhavyabujji,
Could you please share some sample data to have a test?
Regards,
Daniel He
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |