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.
Hello all,
I am building out a matrix and one of the requirements for this matrix is to have the measures in the rows section of the table. I was able to achieve this by creating a disconnected table and using the SELECTEDVALUES function. The problem I ran into is that the mesaures in the matrix are a mix of whole numbers and percentages and the percentages appear as 0. I checked the percebtage measure in a seperate table and it works so my guess is that the method I used only allows for one data type. Is there a way around this?
Value Selection = VAR Selection = SELECTEDVALUE('Disconnected Table'[Measures], "All") Return SWITCH(TRUE(), Selection = "Webinar Registrants", [Webinar Registrants], Selection = "Webinar Attendees", [Webinar Attendees], Selection = "Webinar Attend Rate", [Webinar Attend Rate], Selection = "Webinar Enrollments", [Evergreen Webinar Enrollments], Selection = "Webinar Enroll Rate", [Evergreen Enroll Rate] )
Hey,
I'm wondering if this will provide what you are looking for:
Mark the matrix table and in the formatting section simply switch the property "Show on rows" from the Values band.
Regards,
Tom
Hi Tom,
Thanks for your response. Unfortunetly, that didn't work. I'm still getting 0 for values that should be percentages.
Hey,
do you use the original measures and did you check the "Format" option for each value from the formatting ribbon from the "Modeling" menu:
Regards,
Tom
Yes. All the measures that are formatted as "Whole Number" appear. Measures that are formatted as "Percentages" come back as 0.
Hey,
can you please create a PBIX file with sample data, upload the file to onedrive or dropbox, and please share the link.
Regards,
Tom
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |