Forum Discussion
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 t...
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.
Hi,
Drag number of passengers to the Table visual and write this measure
=COUNT(Data[Passengers])
Change your visual to a Column chart.
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.
Thank you so much! It works :)