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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
dwel0120
Helper III
Helper III

Using Latest Date in table unless date selected

On my page I have a bar chart based on number of people by dates (daily capture) and then I have a table that represents the YoY change in the number of people. In order to get the latest date to show on the table visual, I created a calculated column that has a 1 on the latest date in the table and then I placed a filter on the table visual to 1. By doing this, I am unable to click on the dates on the bar chart. How would I write the measure to say something like -- show the latest date unless another date was selected?

3 REPLIES 3
v-henryk-mstf
Community Support
Community Support

Hi @dwel0120 ,

 

Can you provide the relevant screenshot information and describe it so that I can answer it for you as soon as possible?


Looking forward to your reply.


Best Regards,
Henry



@v-henryk-mstf As of right now, the visual table on the bottom of the page has to be set at the latest date, so it doesn't sum up the entire data table. 

 

dwel0120_0-1669130970014.png

I want to be able to push on a date on the bar visual and it will populate the table visual below. Since I have the visual table filtered to latest date only, when I push on a date the table is blank. 

dwel0120_1-1669131190397.png

I think I need a measure to put in the DailyYoY table that will say pick the latest date in the dataset unless there is a date that is selected. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.