Disconnected date table and disappearing bars

[Turambar]

I have a table similar to the below:

Records

ID	Quantity	Date	Quarter
KJ19	220050	1/22/2023	Q1 2023
KG5	100100	6/12/2023	Q2 2023
SQ22	50902	2/5/2024	Q1 2024
A9K1	888090	11/30/2023	Q4 2023
LM45	10000	8/1/2023	Q3 2023

I also have a disconnected date table for a slicer.

DateTable

Date

1/1/2023

1/2/2023

1/3/2023

1/4/2023

FilterMeasure = 

VAR _MIN = SELECTEDVALUE(DateTable[Date])

VAR _MAX = SELECTEDVALUE(DateTable[Date]) + 365

RETURN

IF(SELECTEDVALUE(Records[Date]) >= _MIN && SELECTEDVALUE(Records[Date]) < _MAX,1,0)

I am using the above measure as a visual level filter with value set to 1. What I want is for the user to select a single date and for the table visual to display all the records on that date or within a year in the future. This part is working correctly. The part that I am running into trouble with is that I also want a column chart showing the sum for each quarter of records that fall within that range (quantity on the y-axis and quarter on the x-axis). When I have the date on the x-axis it shows a column summing up the quantity per month but when I replace this with the quarter field the columns disappear. I think I am missing something very basic but it's eluding me. Any help would be appreciated.

[v-yueyunzh-msft]

Hi , @Turambar 

According to your description, you want to filter the visual by your measure . Right?

I test you data and measure in my side, it works perfectly.

You can put this on the visual like this:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[FreemanZ]

hi @Turambar 

you have this issue, because the Datetable for the slicer is disconnected with the Record table. If you pull the date column in the record table to the slicer, it shall work.