Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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,
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.