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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 10 | |
| 6 | |
| 5 | |
| 5 | |
| 2 |