Forum Discussion
Data filter on multiple date
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.
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.
2 Replies
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.
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.
