Forum Discussion
Dynamically switch dates from Weekly to Monthly in a table
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 !
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.
6 Replies
johnt75Super User
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.
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.
