The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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,