In Line Chart persentage of category data

[Anonymous]

Hi There,

I want to show my data in line chart as persentage of the category. I have handled users' persentage data with "show value as" > "Persentage of Column Total" in this matris visulation.

In this image you can see, I have users' distict count, survey name and answertext. I want to show this persentage of distinct count user data by SurveyName in answertext lines. So I need line chart like this:

[Greg_Deckler]

@Anonymous You can't use Show value as | Percent of Grand Total?

[Anonymous]

@Greg_Deckler It is not usefull for me. I need data like the matrix table.

I want to show answertext's userid's distict count per surveyName. So total survey name persentage count must be 100% per every survey name as I send the last graphic.

Best,

[Greg_Deckler]

@Anonymous OK, not sure so please provide sample source data and expected output from that source data. Need this as text so I can copy and paste into a mockup. Thanks.

[Anonymous]

@Greg_Deckler 

AnswerText Table:

ResponseTable:

Relation:

I need a line chart which must show percent of distictcount userID, comlumn is SurveyName, Rows are AnswerTexts

So I need line chart like this for example:

[Greg_Deckler]

@Anonymous As text please, I don't want to have to type all that data in to mock this up. Thanks.

[Anonymous]

@Greg_Deckler ouw, I'm sorry you are rigtht.

You can find data below:

Answers Table:

ResponseID	QuestionID	QuestionText	AnswerID	AnswerText
XYZ1	Q1	qtext1	q1a1	q1a1text
XYZ1	Q2	qtext2	q2a1	q2a1text
XYZ1	Q3	qtext3	q3a1	q3a2text
XYZ2	Q1	qtext1	q1a2	q1a2text
XYZ2	Q3	qtext3	q3a1	q3a1text
XYZ3	Q1	qtext1	q1a1	q1a1text
XYZ3	Q2	qtext2	q2a2	q2a2text
XYZ3	Q3	qtext3	q3a2	q3a2text
XYZ4	Q1	qtext1	q1a1	q1a1text
XYZ4	Q2	qtext2	q2a1	q2a1text
XYZ4	Q3	qtext3	q3a2	q3a2text
XYZ5	Q1	qtext1	q1a3	q1a3text
XYZ5	Q2	qtext2	q2a1	q2a1text
XYZ6	Q2	qtext2	q2a3	q2a3text
XYZ6	Q3	qtext3	q3a1	q3a1text
XYZ7	Q1	qtext1	q1a2	q1a2text
XYZ7	Q3	qtext3	q3a2	q3a2text
XYZ8	Q1	qtext1	q1a1	q1a1text
XYZ8	Q2	qtext2	q2a2	q2a2text
XYZ8	Q3	qtext3	q3a1	q3a1text

Responses Table:

SurveyID	SurveyName	UserID	ResponseID
SV_1234	survey1	ABC1	XYZ1
SV_1234	survey1	ABC4	XYZ2
SV_1234	survey1	ABC2	XYZ3
SV_1234	survey1	ABC3	XYZ4
SV_5678	survey2	ABC1	XYZ5
SV_5678	survey2	ABC4	XYZ6
SV_5678	survey2	ABC3	XYZ7
SV_9821	survey3	ABC1	XYZ8

[Anonymous]

Hey, I can't fix this problem yet. Is there anyone to help me? I can't find anything about this problem on the web. I know it's very complicated but I think it can be fixed by "power bi" experts.

[Anonymous]

Hi There,

@Greg_Deckler  helped me and I have found participating users both one more survey like this:

Count of Cohort 7c = 
    VAR __tmpTable1 = 
        CALCULATETABLE(
            GENERATE(
                DISTINCT('Table (7)'[UserID]),
                EXCEPT(
                    DISTINCT('Table (7)'[SurveyName]),
                    CALCULATETABLE(DISTINCT('Table (7)'[SurveyName]))
                )
            ),
            REMOVEFILTERS('Table (7)'[AnswerText])
        )
    VAR __tmpTable2 = SUMMARIZE(__tmpTable1,[UserID])
    VAR __tmpTable3 = EXCEPT(DISTINCT('Table (7)'[UserID]),__tmpTable2)
    VAR __CountMax = COUNTROWS(__tmpTable3)

    VAR __Survey = SELECTCOLUMNS('Table (7b)',"__SurveyName",[SurveyName])
    VAR __Question = SELECTCOLUMNS('Table (7a)',"__QuestionText",[QuestionText])
    VAR __tmpTable4 = DISTINCT(SELECTCOLUMNS(FILTER('Table (7)',[SurveyName] IN __Survey && [QuestionText] IN __Question),"UserID",[UserID]))
    VAR __tmpTable5 = FILTER(__tmpTable4,[UserID] IN __tmpTable3)
    VAR __Count = COUNTROWS(__tmpTable5)
RETURN
    IF(ISBLANK(COUNTROWS(__tmpTable4)),BLANK(),IF(__Count > __CountMax,__CountMax,__Count))

However, when I want to see the answers of users participating in more than one survey on the line chart on the basis of the survey, it shows me the distribution of the answers of all the users who participated in the relevant surveys. I've tried many things, but isn't there a solution?