Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hello,
I had data like below before pivot
| ID | Tag 1 | Tag 2 | Story Point |
| A | X | Y | 2 |
B | X | null | 3 |
| C | Y | Z | 4 |
After Pivot i am able to get the data like below
| ID | Tag | Story point | Tag story point |
A | X | 2 | 2 |
| A | Y | 0 | 2 |
B | X | 3 | 3 |
C | Y | 4 | 4 |
C | Z | 0 | 4 |
Issue here is in visual if iam selecting tag & tag story points. I can see 2 rows for the value X in Tag column
Please ignore the story points number. Forgot to change the number according to the above requirement.
Basically i dont want 2 values of X i want only 1 X with that total values of Tag story point. Under column (tags) also i am able to see 2 different X's like below
Can you please help with the above issue
Solved! Go to Solution.
Please ignore found out the issue is due to white space at the leading of the words. So removed that white spaces and visuals/data is not getting duplicated
Please ignore found out the issue is due to white space at the leading of the words. So removed that white spaces and visuals/data is not getting duplicated
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.