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.
I need to create a table visualization that shows either the request created within the past 20 days or request that are completed within the last 20 days using a slicer or chiclet with two options: Created, Complete. Is this possible?
I have the following source data structure
Request
Request | Created | Completed | ||
A | 07/14/2020 | 08/25/2020 | ||
B | 08/14/2020 | 08/20/2020 | ||
C | 08/20/2020 | 08/24/2020 | ||
D | 08/20/2020 | null | ||
E | 08/23/2020 | null |
If I select the created option in my slicer/chiclet I would like to show the following:
Date | Request | |
08/14/2020 | B | |
08/20/2020 | C | |
08/20/2020 | D | |
08/23/2020 | E |
But if i click the completed option in slicer/chiclet I would like the table visualization to show:
Date | Request | |
08/20/2020 | B | |
08/24/2020 | C | |
08/25/2020 | A |
Solved! Go to Solution.
Hi @ablacknerd
The easiest solution is to unpivot the Created and Completed columns
Add the Request and value fields to the table, and add a filter for value - the last 20 days.
Use Attribute as a slicer.
_______________
If I helped, please accept the solution and give kudos! 😀
Yes, you can do this in Power Query editor.
When you download data to Power BI, click Edit or Transform, and a Power Query window will appear.
If you have closed it, click on the Transform Data icon.
In the Query editor select (with Ctrl) two columns and click unpivot Columns and that's it. Apply changes and do next steps.
_______________
If I helped, please accept the solution and give kudos! 😀
I made some mistakes in the values displayed in my original post. This has been corrected.
Hi @ablacknerd
The easiest solution is to unpivot the Created and Completed columns
Add the Request and value fields to the table, and add a filter for value - the last 20 days.
Use Attribute as a slicer.
_______________
If I helped, please accept the solution and give kudos! 😀
My Data source is a Sharepoint list. Is there a way I could unpivot the data in power bi instead of the source
Yes, you can do this in Power Query editor.
When you download data to Power BI, click Edit or Transform, and a Power Query window will appear.
If you have closed it, click on the Transform Data icon.
In the Query editor select (with Ctrl) two columns and click unpivot Columns and that's it. Apply changes and do next steps.
_______________
If I helped, please accept the solution and give kudos! 😀
Thanks again! This is exactly the help I needed
Thanks! This will work.
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 |
---|---|
109 | |
100 | |
84 | |
76 | |
65 |
User | Count |
---|---|
120 | |
111 | |
94 | |
83 | |
77 |