Hi there,
I am doing a report , where i import Data from Postgres and SQL.
Data are fine, my goals are :
- Need to finalize a slicer wich enable user to select fixed time period , and manual mode where the user can use the slider DATE and chose a specifi time range ( today, yesterday, last business week ( sunday to satursday, and the manual mode )
- Choose specified Work shift
- Display data from the choosen time periode + Shift in other dashboard in the powerbi
My problems are :
- When i select last week ( semaine derniere ) , data are not equivalent as if i would have choose them in the manual range date slicer
- Options disapears in Periode when i move cursor for random dates
I created a SpecialDates , to enable choice in my slicer.
So i can have this in my other slicer
I manage to block the DATE slicer when today, yesterday , last week is choosen
with this filter in the Date dashboard
I am not sure if it's a problem with my formula in special dates, of something i missed in the 2 slicers.
Also i don't know if ADDCOLUMNS(FILTER(_datetable,[Date]>_thisweekstart-1),"Période","La Semaine Dernière","Order",3), is a good way to choose the weeknumber before the actual week number.
Hope someone will have a clue ! thanks
Hi there !
I am not sure for the privacy settings as this is for business matters. My main problems is showings data from the Last week ( by last week i mean the last week number going from sunday to satursday )
Hi @Naicweo ,
Could you please provide your pbix file without privacy information and desired output with more details?
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
