Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create column chart from SharePoint Online list

Hi, I am new to Power BI. I am fetching data from SharePoint Online. The table looks like: I want to make a bar chart with the count of each Theraputic Area (Fertility, Oncology, etc). To c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

I am confused about your measure. 

From your statement, you created multiple measures to get the count of each Theraputic Area (TA).

Ex: TA1= Neurodegenerative Diseases

So your measure should use "=" instead of"<>" in filter.

TA1 = CALCULATE(COUNTROWS('SWDHomeList'),'SWDHomeList'[TherapeuticArea] = "Neurodegenerative Diseases")

If you want to count each Therapytic Area in X axis, you can add this column directly in visual and power bi has count function in visual. You don't need to build multiple measures to count.

 

Best Regards,

Rico Zhou

 

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