Forum Discussion
Helper IGrouping data to display at different levels
Hi! I added the data into Power BI, then went into Power Query to unpivot most of the columns. I selected Organisation, Dept, and Loc then went to Transform ribbon and clicked the down arrow on 'Unpivot Columns' and selected 'Unipivot Other Columns'. This step puts the data into this format:
You can name your columns that it created anything you want, I just left mine the default names for this exercise.
Next, I split the Attribute column by delimeter with space as the delimeter and chose left most occurance:
Now, we have data like this:
Next, I click close and apply.
Next, I created a measure for vehicle count as Vehicle Count = SUM ('YourTable'[Value])
Now, you can create visuals and filters however you want:
Super UserHi! I added the data into Power BI, then went into Power Query to unpivot most of the columns. I selected Organisation, Dept, and Loc then went to Transform ribbon and clicked the down arrow on 'Unpivot Columns' and selected 'Unipivot Other Columns'. This step puts the data into this format:
You can name your columns that it created anything you want, I just left mine the default names for this exercise.
Next, I split the Attribute column by delimeter with space as the delimeter and chose left most occurance:
Now, we have data like this:
Next, I click close and apply.
Next, I created a measure for vehicle count as Vehicle Count = SUM ('YourTable'[Value])
Now, you can create visuals and filters however you want:
mnt23Thanks! The unpivot step was what I was really struggling with.
I appreciate the help!