Visualization with detailed count

[Anonymous]

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 .

[V-lianl-msft]

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]

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 · Accepted solution]

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.

[amitchandak]

 I did get it completely.

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