Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I want to set up a calendar that scales according to the minimum and maximum date of a column for each of the RLS roles.
Example:
- Global role :
Min column date : 01/01/2021, Max column date: 12/31/2021
Calendar start date : 01/01/2021, Calendar end date: 31/12/2021
Year month segment : 01/21 to 12/2021
- Role 1 :
Minimum date column : 05/06/2021, Maximum date column: 25/07/2021
Calendar start date : 05/06/2021 , Calendar end date: 25/07/2021
Year month Slicer : 06/21 to 07/2021
- Role 2:
Minimum date column : 08/09/2021, Maximum date column: 10/11/2021
Calendar start date : 08/09/2021 , Calendar end date: 10/11/2021
Year month Slicer : 09/21 to 11/2021
By setting the calendar start date to MIN(table[column date]) or FIRSTDATE(table[column date]) , the MIN/FIRSTDATE functions bypasses the RLS by always bringing up the global minimum date
Thanks
Solved! Go to Solution.
Hi @Plfrcs ,
Please find the below solution,
Date Dimension table,
Create the below measure,
By default it would be like below,
While you do the RLS based on the user, Dates in the slicer will be based upon the selected user as below,
Please like and mark my post as a solution if it answers your question. Thanks.
Hi @Plfrcs ,
Please find the below solution,
Date Dimension table,
Create the below measure,
By default it would be like below,
While you do the RLS based on the user, Dates in the slicer will be based upon the selected user as below,
Please like and mark my post as a solution if it answers your question. Thanks.
You have to distinguish between row filtering (what RLS does) and DAX function basics - if you use a function like CALENDARAUTO it will always create full calendar year ranges even if you limit the fact dates.
Use your own Calendar table, and refrain from using certain DAX time intelligence functions.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |