Forum Discussion

sandraCortes's avatar
sandraCortes
Helper I
2 years ago
Solved

How to include rows with date null using a date range slicer

Hello Everyone,

I have an issue that I don't know how to handle, someone can help me?

In a report we have a slicer for a date range and a table that retrieves data according to that filter and other slicers. However the user wants to include in addition to the rows that correspond to the date range, all rows that have a null date.

 

I added to the fact table query all the rows with null date and I can show them in the table, however when  the user applies the date range filter these ones dissapear from the table. This is because of this relationship:

 

 

I appreciate your ideas. 

 

 

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    sandraCortes 

    try to delete the relationship between two tables and create a measure

    Measure = if(ISBLANK(max('Table'[date])),1,if(max('Table'[date])<min('Table 2'[date])||max('Table'[date])>max('Table 2'[date]),0,1))
     
    add the measure to the visual filter and set the value to 1
     
    pls see the attachment below

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    sandraCortes 

    try to delete the relationship between two tables and create a measure

    Measure = if(ISBLANK(max('Table'[date])),1,if(max('Table'[date])<min('Table 2'[date])||max('Table'[date])>max('Table 2'[date]),0,1))
     
    add the measure to the visual filter and set the value to 1
     
    pls see the attachment below