Join 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!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! 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
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.