Forum Discussion
Create a Frequency Histogram from one column
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.
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?