cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
relsharif Regular Visitor
Regular Visitor

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?

Matrix.PNG

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 5
Super User
Super User

Re: Disconnected Sicer with Different Data Types

Hey,

 

I'm wondering if this will provide what you are looking for:

image.png

Mark the matrix table and in the formatting section  simply switch the property "Show on rows" from the Values band.

 

Regards,

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
relsharif Regular Visitor
Regular Visitor

Re: Disconnected Sicer with Different Data Types

Hi Tom,

 

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

Super User
Super User

Re: Disconnected Sicer with Different Data Types

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:

image.png

Regards,

Tom

 

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Highlighted
relsharif Regular Visitor
Regular Visitor

Re: Disconnected Sicer with Different Data Types

Yes. All the measures that are formatted as "Whole Number" appear. Measures that are formatted as "Percentages" come back as 0.

Super User
Super User

Re: Disconnected Sicer with Different Data Types

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 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!