Forum Discussion
ablacknerd
Helper I
6 years agoUse Slicer to dynamically change between Date Columns in Table Visual
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: ...
lkalawski
Resident Rockstar
6 years agoYes, 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! 😀
ablacknerd
Helper I
6 years agoThanks again! This is exactly the help I needed