Data filter on multiple date

[mirfanshahid]

Hi all,

I have patient data with four different dates

1. PK: FormId,

2. Date Of Collection

3. Received Date

4. Validated Date

5. Added date

I have a requirement to show all the four-date data on the same slicer means I can give filter choice on the same page with a different date means 

If I choose the date of collection data can be displayed related to the date of collection data.

same conditions on all dates but I do not want to switch the page.

[v-jingzhang · Accepted solution]

Hi @mirfanshahid 

In Power Query Editor, select all date columns and unpivot them. (I take 3 columns for example.)

In Power BI Desktop, put Attribute column into the slicer. You can change column names per your need.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Ashish_Mathur]

Hi,

In the Query Editor, rIght click on the first column's heading and select "Unpivot other columns".  Now try to build your desired visual.