Forum Discussion
Slicing data
Your current model is not possible to achieve the slicing. please transform your table into something like the following format, then create 2 separate slicers using Date and Country columns.Date Country Value1 Value2 31/12/2020 US xx xx 30/11/2020 UK xx xx 31/10/2020 Canada xx xx .. ... .. ..
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Hi there, I didnt put any slicer on there at all. I'll do it and post it on.
This time I just tried to do Australia and Brazil. The attempted county slice is below the date slice.
Thanks Daniel.
Your current model is not possible to achieve the slicing. please transform your table into something like the following format, then create 2 separate slicers using Date and Country columns.Date Country Value1 Value2 31/12/2020 US xx xx 30/11/2020 UK xx xx 31/10/2020 Canada xx xx .. ... .. ..
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.That did the trick. Thank you for taking the time to reply.