Forum Discussion
mirfanshahid
5 years agoNew Member
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 ...
- 5 years ago
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.
v-jingzhang
Community Support
5 years agoHi 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.