Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Tom,

       

      Thanks for your response. Unfortunetly, that didn't work. I'm still getting 0 for values that should be percentages.

      • TomMartens's avatar
        TomMartens
        Icon for Super User rankSuper 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