- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

2 Slicer + Dates options and manual selection error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 )

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-03-2024 04:55 AM | |||
07-26-2024 06:10 PM | |||
05-28-2024 12:56 AM | |||
07-29-2024 02:30 PM | |||
10-07-2024 07:16 AM |
User | Count |
---|---|
86 | |
82 | |
42 | |
40 | |
35 |