Dubai Power BI & Power Apps User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
 View Only
  • 1.  Date Filter

    Bronze Contributor
    Posted Mar 26, 2018 03:17 AM
    Dear All,
     Can I add below filter in Power BI,

    WHERE Calendar Date (Default System Date) BETWEEN Start_Date AND End_Date-1

    In above filter only Calendar date will be show on Power BI page but pass the value to Start and End Dates.

    Qasim SM
    BI Consultant
    Deyaar Properties

  • 2.  RE: Date Filter

    Posted Oct 09, 2018 08:04 AM
    Edited by Madara Dassanayake Oct 09, 2018 08:05 AM
    Hi ,

    You could do something like below if you need to add a filter for  a specific date range.

    1. Add a new conditional column to your dataset based on your criteria.

    Datefilter = IF(Calendar Date (Default System Date) >Start_Date &&  Calendar Date (Default System Date) <End_Date-1,1,0)

    2. Now you can add this column as a visual,report or page level filter.

    as Datefilter =1

    Hope this answer to your question.


    Madara Dassanayake
    Business Intelligence Consultant

  • 3.  RE: Date Filter

    Top Contributor
    Posted Oct 29, 2018 06:12 PM

    I am sure you have a Date Dimension in your data model & its linked with your fact at day level grain.

    Now drag [Date] from date dimension & select [Slicer] visual from visuals section.

    Change the layout of slicer visual to relative, this will let you pick start & end date from your fact table.

    Hasham Bin Niaz
    Sr. BI Consultant
    Karachi, Pakistan