Forum Discussion
Switching hot(current) and cold(previous) data values on the same table visual using switch/slicer
I am kind of stuck in implemented this idea. Could anybody please help. If I choose Hot, i want to display the current month data and rest will all be the previous. I have already splitted the da...
PhilipTreacy
Super User
Super UserHi Anonymous
If you have a table with data like this including a column that specifies the row as either hot (this month) or cold (a previous month)
then you can use a slicer to filter the data as you describe
Regards
Phil
Thank you for sharing the solution.
The above works fine when i have both the hot and cold data merged together as a single table.
But in my data, there are two tables, 1. Hot data table ( i am getting using import - only the recent 3 months data) and 2. Cold data Table (using direct query - data that is older than 3 months).
So in that case, i want to retrive from two different tables on a single visual.
Thank you 🙂