Create column chart from SharePoint Online list with data modelling

[Anonymous]

Hi,

I am new to Power BI.

My data set looks like this:

I want my column graph to look like this:

How do I achieve this?

Thanks in advance for all the help.

[amitchandak]

@Anonymous , This counts pets with pets on-axis.

With conditional formatting measure with field value option

Color = Switch(true(),

max(Table[Pets] ="Cat" , "Red",

max(Table[Pets] ="Dog" , "Yellow",

// Add other

"Green" //default

)

For conditional formatting refer PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[Anonymous]

Hi @amitchandak ,

But in order to achieve this, I think my data source should look like this:

How do I model it in this way?

[amitchandak · Accepted solution]

@Anonymous , No pets on axis and a measure 

measure = count(Table[Pets]) on values should do

If you want a table

new Table  =

summarize(Table, Table[pets], "Count", count(Table[Pets]))

[Anonymous]

@amitchandak Thanks a ton! Worked perfectly.