Add extra row to matrix visual

Question

Hi,&nbsp;I have a query which lists below questions and answers:UserIdDateQuestion keyAnswer1000120-6-2024Select which side effects you are experiencingOK1000120-6-2024Joint paintrue1000120-6-2024Fatiguefalse1000120-6-2024Skin rashtrue1000120-6-2024Multiple instances of dizzinessfalse1000120-6-2024Feeling feverishfalse1000120-6-2024Diarrheafalse1000120-6-2024Lack of appetitefalse1000120-6-2024Shortness of breathfalse1000121-6-2024Select which side effects you are experiencingOK1000121-6-2024Joint painfalse1000121-6-2024Fatiguefalse1000121-6-2024Skin rashfalse1000121-6-2024Multiple instances of dizzinessfalse1000121-6-2024Feeling feverishfalse1000121-6-2024Diarrheafalse1000121-6-2024Lack of appetitefalse1000121-6-2024Shortness of breathfalseetcetcetcetc&nbsp;As you can see the user answers "Joint pain" &amp; "Skin rash" as side effect he/she is experiencing on day 20-6.On day 21-6 the same user experiences no side effects.I want to create a matrix visual like this:But the option "None of the above side effects" is not a question so it won't appear in the records.Do you have a solution for this?Thanks!govi

amitchandak · Answer

govi , We usually add the extra value to the dimension table and force a different calculation for that value.
&nbsp;
I have done it using the extra table here, but the same can be forced on the dimension table
&nbsp;
Power BI How to get the P&amp;L formatting right with additional sub totals: https://youtu.be/C9K8uVfthUU Power BI How to get two columns format Profit and Loss Statement(P&amp;L) right: https://youtu.be/WLg85yiMgHIhttps://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e39ca822908a
&nbsp;

Forum Discussion

Add extra row to matrix visual

1 Reply

Related content

Matrix Visual Duality

Custom Matrix Visual

Power Matrix visual

Matrix visual shows extra blank rows (abnormal)

Formatting Matrix Visuals

UserId	Date	Question key	Answer
10001	20-6-2024	Select which side effects you are experiencing	OK
10001	20-6-2024	Joint pain	true
10001	20-6-2024	Fatigue	false
10001	20-6-2024	Skin rash	true
10001	20-6-2024	Multiple instances of dizziness	false
10001	20-6-2024	Feeling feverish	false
10001	20-6-2024	Diarrhea	false
10001	20-6-2024	Lack of appetite	false
10001	20-6-2024	Shortness of breath	false
10001	21-6-2024	Select which side effects you are experiencing	OK
10001	21-6-2024	Joint pain	false
10001	21-6-2024	Fatigue	false
10001	21-6-2024	Skin rash	false
10001	21-6-2024	Multiple instances of dizziness	false
10001	21-6-2024	Feeling feverish	false
10001	21-6-2024	Diarrhea	false
10001	21-6-2024	Lack of appetite	false
10001	21-6-2024	Shortness of breath	false
etc	etc	etc	etc