Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Disconnected date table and disappearing bars

I have a table similar to the below:



KJ192200501/22/2023Q1 2023
KG51001006/12/2023Q2 2023
SQ22509022/5/2024Q1 2024
A9K188809011/30/2023Q4 2023
LM45100008/1/2023Q3 2023


I also have a disconnected date table for a slicer.






FilterMeasure = 



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




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.


Community Support
Community Support

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

Super User
Super User

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. 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors