Can one date visual affect several date columns?

[AliceW]

Hi ladies and gents,

I'm not sure this is possible, but it would be amazing if it were.

So, I'm having this huge table on Leads, and within I have FOUR separate date columns:

- Created Date

- Change Date

- Moved Date

- Closed Date

I'd like the users to select a period in ONE date visual (say, last 7 days), and the report to display the number of Leads:

- Created

- Changed

- Moved

- Closed

in that period, in separate visuals.

Please please help.

Best,

Alice

[AliceW · Accepted solution]

Found the answer here: https://community.powerbi.com/t5/Desktop/Use-a-single-date-range-slicer-for-several-visualizations-w...

[camargos88]

@AliceW ,

You can unpivot these 4 columns using power query. So you have 1 column for date and other for "date event"...

you can use a slicer for this date column and filter what you need, even interacting with other visuals.

[AliceW]

Hmmm, I'm not sure what you mean by unpivoting. They are different columns at the moment...