Slicer configuration

[Anonymous]

Hi,

I have 2 fact tables in my dashboard where one have data until May'2020 and other have data until April'2020.

When I put a slicer in my dashboard I want that appear only until April, but I have May button showing up too. I cannot apply a filter only in months 1 (January) to 4 (April), because I have data from other years that I need to view. But 2020, I want the slicer to appear only until April.

I try apply advanced filtering "is not blank" but it doesnt work.

How can I do that?

[v-easonf-msft]

Hi , @Anonymous 

Not very clear what you want.

Is this the result you want?

If it is , try to create a visual control measure  and apply it into  filter pane of the slicer.

Measure = 
var d=IF(MAX('Table 1'[Date])<MAX('Table 2'[Date]),MAX('Table 1'[Date]),MAX('Table 2'[Date]))
return IF(SELECTEDVALUE('Date'[Date])<d,1,0)

pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-easonf-msft, not exactly.

Look the image below, when I click in May button I don't have any information, because I have data only in 1 table. But I don't want this option show in 2020 until I have the data of May in the 2 fact table.

For this view is calculate: (total value from table 1/ total value from table 2), but until May is over I will not have the information in the two tables and that generates that blank information, so I don't want the May button to appear yet.

[amitchandak]

@Anonymous , Are you using common Date table that is generated using calendarAuto or Till max of two tables or till and end date?

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/