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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.