Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Turambar
Frequent Visitor

Disconnected date table and disappearing bars

I have a table similar to the below:

 

Records

IDQuantityDateQuarter
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.

 

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.

 

2 REPLIES 2
v-yueyunzh-msft
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:

vyueyunzhmsft_0-1670204721392.png

 

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
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

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors