Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Dynamic double Top 10

Hi    I need help with this scenario   I have sales data which has product name, product group, region and sold units for year 2016 and 17 I want to display top 10 product groups based on the un...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    Hi, i'm not sure if this what you need.

     

     

    Use a Slicer to Regions

    Use the New Table Visual to show the Top 10 Product Group

    Use a Table to show the top 10 Products of the selected Group.

     

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Anonymous

 

Hi, i'm not sure if this what you need.

 

 

Use a Slicer to Regions

Use the New Table Visual to show the Top 10 Product Group

Use a Table to show the top 10 Products of the selected Group.

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

hi Vvelarde

 

This is exactly what i need just would like to have it in slicer, instead of new table so i can put it horizontal slicer on top of the dashboard. 

 

I would say it is alternative solution and i will try it out 

 

thank you 

 

 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    Anonymous

     

    You can have a better look with a tree Map. 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      hi Vvelarde

       

      How did you make all the groups equal size. When i try my data the panels are different sizes and i coulndt find the option to adjust it

       

      thank you 

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        9 years ago

        Anonymous

         

        I use a distinct count of Product Group in Values Section