Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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
        Super 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