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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

data filter between two visuals

Hi All,

 

In one visual we need to display one day data and other visual we need to display all dates data. If we click on first visual values, in 2nd visual need to display all dates data for selected value in 1st visual.

 

issue:

it is displaying only one day data in 2nd visual.

 

Thanks in advance.

 

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous 

Assume you have date D1 in your table and joined with Date D2 in date dimension. Make sure you create Visual 1 Date of the filter a give a visual level filter on the date from the table.

In the Second visual Take the Date from dimension and Try. If require use take measure with All on date

 

Measure Two = Calculate([Measure], All(Date[d2]))

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

HI Amit thanks for your reply but we don't have date dimension in our report

Anonymous
Not applicable

Hi @Anonymous ,

It seems you want to filter the data in Visual 2 by the selected date value on Visual 1... Could you please provide some sample data and screen shot for your expected result? The date on visual 1 and visual 2 are from same field?

Best Regards

Rena

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.