Forum Discussion
Disconnected Sicer with Different Data Types
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]
)5 Replies
- TomMartensSuper User
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
- AnonymousNot applicable
Hi Tom,
Thanks for your response. Unfortunetly, that didn't work. I'm still getting 0 for values that should be percentages.
- TomMartensSuper User
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