Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The title does not explain this properly but here is the issue. I work in insurance and I have a matrix and in the rows i have put Policy Number. In my dataset there can be multiple rows with the same policy number but in the matrix, it combines them into one row and as a result, makes me pick the "first, last, sum, average, etc." of the values portion. How can i make it so it shows every iteration of the policy numbers in the rows section? I have attached pictures below. As you can see in the first picture, there are FOUR rows in my dataset. this is because there are endorsements added on to the policy that get their own row. we need to see each individual transaction for each policy number.
Howevere here in the picture below, when i put it in a matrix, it only shows the policy number once. it forces me to pick the First source and sum the location number. How can i make it so it shows all 4 of the transactional data rows in the matrix?
Solved! Go to Solution.
You could add an index column to the table and add it to the visual:
Proud to be a Super User!
Paul on Linkedin.
You could add an index column to the table and add it to the visual:
Proud to be a Super User!
Paul on Linkedin.
incredible thank you! I was headed in that direction but you gave me the push over the finish line and for that, i thank you 🙂
If you'd rather not have the index column visible, you can "hide" it by dragging the right boundary (you need to turn off the options of auto-column width and word wrap in the formatting pane)
Proud to be a Super User!
Paul on Linkedin.
You will need to add something to the visual to make each line unique. powerbi is about aggregations (sum, average, etc) and will always try to show grouped data with an aggregation.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |