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 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.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |