Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Create a Frequency Histogram from one column

Hello everyone! I am new using Power BI and also in this forum and a have a little question

¿How do you create an histogram where you can see the number of repetitions of each data?

My problem is that I don't have a summary table. I mean, my data is like this:

 

Occupancy of the car:

1

1

2

2

2

3

 

And I want a graph with 3 columns (a typical histogram :D)

1 person --> 2 repetitions

2 person --> 3 repetitions

3 person --> 1 repetition

 

Thank you in advanced 🙂

 

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

Here is one way. Go to Modeling tab and create a new table with this formula:

 

Table5 = DISTINCT(Table4[Occupancy of the car:])

Now, in that table, create a new column with this formula (Table4 is your original table):

 

Column = COUNTX(FILTER(ALL(Table4),Table4[Occupancy of the car:]=Table5[Occupancy of the car:]),[Occupancy of the car:])

Use your new table for your histogram.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Ashish_Mathur
Super User
Super User

Hi,

 

Drag number of passengers to the Table visual and write this measure

 

=COUNT(Data[Passengers])

 

Change your visual to a Column chart.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

 

Drag number of passengers to the Table visual and write this measure

 

=COUNT(Data[Passengers])

 

Change your visual to a Column chart.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Greg_Deckler
Super User
Super User

Here is one way. Go to Modeling tab and create a new table with this formula:

 

Table5 = DISTINCT(Table4[Occupancy of the car:])

Now, in that table, create a new column with this formula (Table4 is your original table):

 

Column = COUNTX(FILTER(ALL(Table4),Table4[Occupancy of the car:]=Table5[Occupancy of the car:]),[Occupancy of the car:])

Use your new table for your histogram.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler Say we had an additional colum in Table 4 which had three different car colours; red, blue, and yellow. The data could look like:

Occupancy of the car:    Car Color:

1                                     Red

1                                     Blue

1                                     Blue

2                                     Red

3                                     Yellow

3                                     Red

 

I want to be able to filter the relative frequency graph for each car color. How would I do this?

Anonymous
Not applicable

Thank you so much! It works 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.