Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Visualization with detailed count

Hi All 

Need your suggestion .   I have 4 countries and each country has type A , Type B , Type C category product,

 

I want to show the visualization with each country Vs . The count of Type A / B / C Product 

 

Please suggest .

  • Hi Anonymous ,
     
    "Country" on Axis field.
    For more details,you can refer to the picture.
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  •  I did get it completely.

    You can show the same in a matrix. By taking count of the products.

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    Hi Anonymous ,
     
    Using the product column as a slicer might meet your needs.
     
    Best Regards,
    Liang
    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

      Thanks Liang , This certainly helps .

       

      I have few questions which would help me to accept it as solution .

       

      So on the same page , I think i need to select one slicer and one stacked bar chart ? Correct me if i am wrong .

       

      In the slicer , i will certainly put the product category ( in drop down )

       

      But , Then in the stacked barchart ,the country name you are putting where ?  Is it in the Axis  ( OR ) Legend ( OR ) value ?

       

      Because if i put Country Name in the value , then i do not get a visualization like yours .

       

      Please suggest which field to put in which place ?

       

       
       

      Thanks

      Sameer

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        Hi Anonymous ,
         
        "Country" on Axis field.
        For more details,you can refer to the picture.
         
        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.