Forum Discussion

Occo's avatar
Occo
Regular Visitor
5 years ago
Solved

Slicing data

Hi All, new to Power BI but very excited by it.   Curently I am trying to slice my data. I have an "economic statistic" per county (about 15) starting from 1985 to the end of Dec 2020. Ultimately I...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Occo 


    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.

Occo's avatar
Occo
Regular Visitor
5 years ago

This time I just tried to do Australia and Brazil.  The attempted county slice is below the date slice.

Thanks Daniel.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Occo 


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.

  • Occo's avatar
    Occo
    Regular Visitor
    5 years ago

    That did the trick. Thank you for taking the time to reply.