Forum Discussion

RuthMerchán's avatar
RuthMerchán
Icon for Helper I rankHelper I
3 years ago

How to show all dates although data does not exist taking into account a range of dates?

I eneryone!   This report is formed by 3 tables (date1 (dimension table of date 1), fact_table and date2 (an independent dimension table of dates)). So that it is shown a table with the last 20 da...
Need Help
Show and Tell
Tips and Tricks
Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
3 years ago

You can put a visual level filter to have your visual only display the last 20 days.

 



  • RuthMerchán's avatar
    RuthMerchán
    Icon for Helper I rankHelper I
    3 years ago

    Hi Syk, 

     

    it does not work. When I make this filter on this table 2, anything is shown because it takes last days until today, As I have filtered 20 April on slicers, when I apply this filter, table2 is empty.

     

    I have tried to limit this table creating another table with a range of dates between max value of date (in this case would be 20 April) and min date (in this case 20 April -20 ) but it does not work neither...

     

    Thank you for your help