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.
Hi
I have the following setup
Item No Category Direction1 Direction2 Value Value3
10006 Cat1 Pay 100
10006 Cat1 Rec 125
10007 Cat1 Pay 98.5
10007 Cat1 Rec 88.4
How can i show the values for the same item & Category in one row and not have them split into multiple rows.
Any help will be appreciated.
You should apply Grouping on "ItemNo and Category" Columns
Add Grouping to Table Reports in SSRS (tutorialgateway.org)
Proud to be a Super User!
Dear @FarhanAhmed Thank you for the reply, and i did as suggested. Did the grouping based on Item # and Category from the rows tab below the canvas, however the result is still the same. The values are still coming in 2nd row. Tried different combinations for grouping, but didnt work.
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 |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |