Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
13 | |
13 | |
13 | |
9 |