Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Line Chart with 5 Variables

Does anyone know of a visualization that can display data with 5 variable fields? I'd like to display all the data in one chart and allow the user to use slicers to decide what data they would like to see. 

 

Here is a simplified dataset. I'd like to be able to see all the lines at one time and then use slicers to adjust as necessary.

 

Thank you in advance!

 

 

LocationRadiusDateOccupationEmployees
Dallas10 Miles2020Q1Clerk8
Seattle10 Miles2020Q1Clerk4
Miami10 Miles2020Q1Clerk8
Dallas10 Miles2020Q2Clerk3
Seattle10 Miles2020Q2Clerk24
Miami10 Miles2020Q2Clerk33
Dallas20 Miles2020Q1Clerk47
Seattle20 Miles2020Q1Clerk14
Miami20 Miles2020Q1Clerk22
Dallas20 Miles2020Q2Clerk36
Seattle20 Miles2020Q2Clerk44
Miami20 Miles2020Q2Clerk23
Dallas10 Miles2020Q1Stocker12
Seattle10 Miles2020Q1Stocker32
Miami10 Miles2020Q1Stocker53
Dallas10 Miles2020Q2Stocker52
Seattle10 Miles2020Q2Stocker64
Miami10 Miles2020Q2Stocker52
Dallas20 Miles2020Q1Stocker41
Seattle20 Miles2020Q1Stocker19
Miami20 Miles2020Q1Stocker17
Dallas20 Miles2020Q2Stocker11
Seattle20 Miles2020Q2Stocker16
Miami20 Miles2020Q2Stocker31

 

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you Phil, I'll try it today and see how it comes out. 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    It’s my pleasure to answer for you.

    According to your description,I think you can use a table visual and four slicer to display and filter data.

    Like this:

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you Janey. That's what I have now, so the user can view how they want.  I'd just like to have one graphic to portray it. Appreciate the help as I know it's not an easy question.