Forum Discussion
Create column chart from SharePoint Online list with data modelling
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.
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]))
4 Replies
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
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?
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]))