Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cross Filtering calendar table

I have a calendar table that goes from 1901 up to 2020 and another tables have data from 2018 to 2020. When I add a slicer, it shows dates from the entire period in the calendar table. How do I displa...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    v-lili6-msft,

     

    Thanks for your comment. I found a much simpler solution. When you add a column to the values bucket, only the records with data in that column appears in the filter list.

     

    Thanks,

    Anton

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-lili6-msft,

 

Thanks for your comment. Attached is an image of my report. My matrix table is already showing only the dates with data. And I have multiple aggregated columns in it. 

What I'm trying to achieve is to show only dates with data in my filter visualization which is on the left. Hope this makes sense. 

Please let me know if you need any further details.

 

 

Thanks, Anton

Aruljoy's avatar
Aruljoy
Helper II
5 years ago

Hi Afernado,

 

Can you please provide me the sample PBIX file which you have in the image. I need to genrate simillar report? 

 

Thanks,

Arul Arockiam