best visual to display diversified vendor's expense

[River]

Hi Friends,

In our vendor table, each vendor is marked as 'small business', 'female owned', 'disabled owned'..., each type is a separated column, with value 1 or 0. 

we want to find out how much we do business with each type, how can I use a single bar chart or whatever visual to tell each type's expense.

Thanks,

[v-stephen-msft · Accepted solution]

Hi @River ,

You can select the columns you need, then unpivot.

Then you'll get this table.

This way you can put the attribute column into Legend. The attribute column can also be put into slicers for filtering.

Best Regards,

Stephen Tao

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

[v-stephen-msft · Accepted solution]

Hi @River ,

You can select the columns you need, then unpivot.

Then you'll get this table.

This way you can put the attribute column into Legend. The attribute column can also be put into slicers for filtering.

Best Regards,

Stephen Tao

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

[River · Accepted solution]

That works. Thanks a lot!

[River]

@amitchandak , thanks for response, but, difficulty I had is that those types are in different columns/fields.

How can you put them in a stacked chart or pie? 

[amitchandak]

@River , Stacked visual. Pie with details