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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Frixel
Post Prodigy
Post Prodigy

How to select different dates

Hi all,

 

I want to be able to work in an overview with 2 different dates.
How should I do that if not all tables respond to the different dates?

i mean that i will select differents dates and different ID nr in the view.

Maybe it has a special name so I can't figure out how it works?

2023-11-08_15-41-57.png

1 ACCEPTED SOLUTION
v-junyant-msft
Community Support
Community Support

Hi @Frixel ,

I'm not sure if I've understood your problem correctly, I'll elaborate on my solution.
First, let me show you my test data:

vjunyantmsft_0-1699596871205.png

I created two identical slicers based on the 'Date modified' column:

vjunyantmsft_1-1699596920028.pngvjunyantmsft_2-1699596924815.png

Then I created two table visuals:

vjunyantmsft_3-1699596948300.png

Select the slicer on the left, click 'Format', click 'Edit interactions', disable the table and slicer on the right, and no operation is required on the left:

vjunyantmsft_4-1699596977897.png

Then follow the same steps, select the slicer on the right, click 'Format', click 'Edit interactions', disable the table and slicer on the left, and no operation is required on the right:

vjunyantmsft_5-1699597012039.png

The final result is shown in the following figure:

vjunyantmsft_6-1699597038251.png

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



View solution in original post

14 REPLIES 14
v-junyant-msft
Community Support
Community Support

Hi @Frixel ,

I'm not sure if I've understood your problem correctly, I'll elaborate on my solution.
First, let me show you my test data:

vjunyantmsft_0-1699596871205.png

I created two identical slicers based on the 'Date modified' column:

vjunyantmsft_1-1699596920028.pngvjunyantmsft_2-1699596924815.png

Then I created two table visuals:

vjunyantmsft_3-1699596948300.png

Select the slicer on the left, click 'Format', click 'Edit interactions', disable the table and slicer on the right, and no operation is required on the left:

vjunyantmsft_4-1699596977897.png

Then follow the same steps, select the slicer on the right, click 'Format', click 'Edit interactions', disable the table and slicer on the left, and no operation is required on the right:

vjunyantmsft_5-1699597012039.png

The final result is shown in the following figure:

vjunyantmsft_6-1699597038251.png

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



Hi @v-junyant-msft 

 

Thank you, I have now set it up this way and it works perfectly

egm_2013
New Member

I recommend having two different date filters as well as an independant calendar within your tables such as a fiscal calendar . So filter one: Date Entered , Filter two : Date modified. 

@egm_2013 

 

I don't quite understand that(sorry). I only have one date column in my table

JoBI
Resolver I
Resolver I

Yes to select different elements from visuals simultaneously you need to press Ctrl+click. Alternatively you can change the first two date tables to slicers.

CMajka8
Helper I
Helper I

instead of having the date values in a table, can you put them in a filter visual and select the data range using the date picker or slider?

date picker is not a standard visual?

Based on the other images you posted, it appears you may need to set up a proper Date table in your model and create the relationship with your fact table first.

If it is a proper date field then Power BI will recognize it, so when you add the field to the slicer it should appear like this, by default:

CMajka8_0-1699464605590.png

 

oke, but i will select 2 different dates because there are then 2 diffents of outcomes 

Perhaps I misunderstood. I was under the impression you were looking to select the date range, i.e., Begin Date and End Date?

No, i will select on both date`s visuals checks a date to compate the outcomes in the tables

JoBI
Resolver I
Resolver I

Hello,

I think what you want to check is the "Edit interactions" functionality in the Format tab here: 

JoBI_0-1699457335582.png

This way you can cancel out the interaction from first table to the other ones etc.

Hope this helps

Hi @JoBI 

 

Thanks =, Yes that is what i am looking for 👍

 

But now i have the problem that i can`t select two different dates because then the other dat is then going back to default. I hope you know what i mean?

When i click on the date in yellow the date from table 1 is going to default.

 

2023-11-08_16-37-23.png

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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