Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to create a matrix visualizations in which I want to show field value in both row (Actual Value) and its percentage under a year column header.
Solved! Go to Solution.
You need fixed column headings,
then create the measure like below and put it into Values field
Measure = SWITCH(TRUE(),
MAX('Table'[Column2])="Actual", 1,//replace 1 with your % Rev
MAX('Table'[Column2])="% Rev",2) //replace 1 with your Actual
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
You need fixed column headings,
then create the measure like below and put it into Values field
Measure = SWITCH(TRUE(),
MAX('Table'[Column2])="Actual", 1,//replace 1 with your % Rev
MAX('Table'[Column2])="% Rev",2) //replace 1 with your Actual
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.