I would like to create a bar chart using data from multiple different columns. How can I do that?

[grimal]

I have a large dataset similar to what is above. I would like to create a bar chart using the data in columns C, D, and E. Essentially, I want to be able to compare how many people created impact at the international, national, and regional level on the same graph.  Does anyone have an idea how I could do that ?

[v-juanli-msft]

Hi @grimal

in Query editor

select columns, and select “Transform”->”Upvoit columns”

Then create measure

COUNT = CALCULATE(DISTINCTCOUNT(Sheet8[person]),ALLEXCEPT(Sheet8,Sheet8[Value]))

Best Regards

Maggie

[grimal]

Hi Maggie,
Thank you for the suggestion. It definitely gives me the overall numbers that I want to see. However, I'm not able to filter my chart by country or person. I want to be able to make visual comparisons within the graph and the "measure" does not interact with my other columns. Do you have a fix for that? 

[v-juanli-msft · Accepted solution]

Hi @grimal

Use this measure

Measure = COUNT(Sheet8[person])

Best Regards

Maggie