pivot table

3 Topics

Group by Measure in a Matrix
I have been searching for answers on this and have found several things that might work but I don't understand how to use them. Hoping someone can help me understand. I will try to explain what all I have and what I am trying to do. I have a measure called AverageDailyWorth that is just a sum of the customers spend divided by the number of trips they have made. I have a second measure using the switch function to roup the customer into ranges based on the AverageDailyWorth. So for example into groups like $0-$14, $15-$49,$50-$99,$100+. The goal is to have a Matrix that lists all of these groupings on the rows and then I can get the combined sum of values in columns for all the members in each group. This is super simple in Excel as I would just do a vlookup to assign to the Grouping and then do a pivot table based on the column from the vlookup. However recreating pivot tables in Power BI seems to be impossible when you are using a measure. At least to me. I have found the following ideas in my reasearch on this and they might or might not wok but with my limited understanding of the I have not gotten a workable solution: disassociated table virtual table virtual relationships I am still very new to Power BI and this foru as well. If there is a way I can provide a file with sample data and that is useful please let me know how. I will gladly make a mock sample file in Power BI as well as the expected result from Excel I would like to recreate.
Solved
ChadPortman
5 years ago Place Report Server
1.1KViews
0likes
2Comments
Pivoting a column and aggregating text values - Power Query
I'm using Power Query in Excel and I'm trying to transform the data below in the image below. This image is a snipper of a larger dataset and shows information for 2 film titles. The data I receive is laid out incorrectly, I want to pivot the 'Fields' column so that it becomes my header row, which I can do using 'Pivot Column', my problem is that I want the 'Value' information to then be listed beneath this. For example, my first column would become Title, and the first two row values for this column should be The Rig and Good Luck To You, Leo Grande. I do not know though how to get the transform to aggregate the data like this and list the values as individual rows under the pivoted column headers. Advice would be much apprecaited.
Solved
maracles
5 years ago Place Report Server
1.1KViews
0likes
1Comment
Require Color Coding For Pivot Table in Matrix Visual (Power BI Server - May 2020)
Hi, Can someone please help me to color code the entire row based on the text value for "Bench category" even if the value is empty or null. Right now in BI, I have obtained below output: But the final output should look like this as shown below: Thank you in advance for the help.
Anonymous
5 years ago Place Report Server
1.1KViews
0likes
2Comments