Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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