Dynamically switch dates from Weekly to Monthly in a table

[amadei]

Hi,
For a while I've been try to find a way to dynamically switch my date column inside a table based on a slicer/button, without any luck !

Here is a visual of what I mean, switch inside the same table;

Week	Sales
1	10
2	10
3	10
4	10
5	10
6	10
7	10
8	10
Month	Sales
1	40
2	40

Any solution other then bookmarks ?

Thanks !

[v-sdhruv]

Hi @amadei ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @amadei ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @amadei ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[johnt75 · Accepted solution]

Create a new field parameter and add your week and month columns to it. Use the field parameter in your table visual, and it will dynamically update according to the selection in the slicer.

[amadei]

Ok i will give it a try !

Can I use a custom slicer or it need to be based on the week/month table?

[johnt75]

When you create the field parameter it will give you the option to automatically create the slicer for you. If you create your own then it needs to use the field parameter column.