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 structureRequestRequest Created CompletedA 07/14/2020 08/25/2020B 08/14/2020 08/20/2020C 08/20/2020 08/24/2020D 08/20/2020 nullE 08/23/2020 null If I select the created option in my slicer/chiclet I would like to show the following:Date Request08/14/2020 B08/20/2020 C08/20/2020 D08/23/2020 E But if i click the completed option in slicer/chiclet I would like the table visualization to show:Date Request08/20/2020 B08/24/2020 C08/25/2020 A

Hi ablacknerdThe 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! 😀

ablacknerd

Helper I

6 years ago

Solved

Use 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: 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

lkalawski
6 years ago
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! 😀
lkalawski
6 years ago
ablacknerd
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! 😀