For the "CARENDERAUTO()" date slicer, only the range corresponding to the data should be displayed.

[saiki]

Hello all,

Assumption: a slicer based on a single calendar table("CARENDARAUTO()") to control visuals. However, different visuals divided into pages have different date ranges (since when or latest data update date).

Objective: In this case, we do not want each slicer to display dates that do not exist in the table.

Question: Can the display range of each slicer be controlled by the date range of the corresponding table, automatically? Or is there another solution?

Additional : If table A is from April to October and table B is from June to December, the calendar table created by CARENDERAUTO() will have a range from April to December. Then the slicer controlling table A would be from April to December, but we want to hide November and December from the slicer because they are unnecessary since there is no data for them.

Your help is very much appreciated, thank you very much!

[eliasayyy · Accepted solution]

yes if you have a calendar table and a fact table , just create a formula 

if( calculate(max(calendar[date])all(calendar)) > calculate(max(table[date])all(table)) , 1 , 0