Forum Discussion
Helper IUse Slicer to dynamically change between Date Columns in Table Visual
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! 😀
Resident RockstarYes, 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! 😀
Helper IThanks again! This is exactly the help I needed