Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two values in [Performance] colum (Actual and Variance) and [Reason] for Variance itself.
what i am trying to do is creating a report having color in rows, performance in column, amount in values. While i created a slicer for reason.
Color Performance Reason Amount
Green Actual Actual 10
Green Variance Known 4
Green Variance Unknown 3
This looks like below report. but when I use the slicer for reason to select known variances it hides the Actual colum from pivot.
Color Actual Variance
Green 10 7
Hope i explained it well, Kindly let me know if i can use filter for varaince and ignore the selection for actual.
Color Variance
Green 4
dont want to hide Actual column over selection
Solved! Go to Solution.
Based on your description, it seems you are using a matrix and put Performace column into a Column group. So when you select Actual reason in slicer, there's no value for Variance column group so that it will not be displayed in matrix.
To keep the Performance column, I suggest you use a table instead of matrix to render your data.
Regards,
Based on your description, it seems you are using a matrix and put Performace column into a Column group. So when you select Actual reason in slicer, there's no value for Variance column group so that it will not be displayed in matrix.
To keep the Performance column, I suggest you use a table instead of matrix to render your data.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |