Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |