CODEWITHSUNDEEP
powerbibar-chartcategorical-data
user3789200
user3789200

Reputation: 1186

Power BI categorical data count in a bar chart

I'm having the Power BI desktop version on my laptop. My dataset consists of a number of categorical data. I need to get the pie chart and the bar chart of the categories against the count. Is there any specific way to do it. We can plot the categorical variable against another numerical value. But not seems like against its own count.

Kindly inform

Upvotes: 1

Views: 12581

Answers (1)

Ronan OMalley
Ronan OMalley

Reputation: 71

If I understand correctly, you are wanting to visual how many times a category appears, against that category.

In Power BI, you can bring in a field more than once into a visualisation and perform different actions on it. I would usually put everything into formulas, but you can use the drop and drag interface too.

Bar Graph

  1. Drag the category field into the shared axis
  2. Drag it into the Column Value to get a count
  3. I dragged category into line values as well to show the %. Right click on the count, then go down to the option "show value as" and select % of grand total.

Upvotes: 2

Related Questions