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]))
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]))
amitchandak Thanks a ton! Worked perfectly.