Need to add slicer selection onto paramater list

[jak8282]

Hi,

We have a paramater slicer which affects a matrix table.

We want to be able to add a column into that matrix table based on what they have selected on the paramater list.

The paramater slicer is 

Comments Switch = {

    ("Exam booking process", NAMEOF('Exam Experience Survey'[EXPROEVAL2_Exam booking process why]), 0),

    ("Examination Dockets", NAMEOF('Exam Experience Survey'[EXPROEVAL2_Examination Dockets why]), 1),

    ("Pre session communication", NAMEOF('Exam Experience Survey'[EXPROEVAL2_Pre session communication why]), 2)

}

The new paramater is

Examples = {
    ("EXPROEVAL1_Exam day experience rating", NAMEOF('Exam Experience Survey'[EXPROEVAL1_Exam day experience rating]), 0),
    ("EXPROEVAL1_Examination Dockets rating", NAMEOF('Exam Experience Survey'[EXPROEVAL1_Examination Dockets rating]), 1),
    ("EXPROEVAL1_Pre session communications rating", NAMEOF('Exam Experience Survey'[EXPROEVAL1_Pre session communications rating]), 2)
}

So for the second paramter we want to say if Selected Value of comments switch slicer  is "Exam booking process" then use the first value of the new paramater and the rest for the second and third.

Thanks

Chris

[Anonymous]

Hi @jak8282 ,

Did you want to dynamic change rows/columns in a matrix visual based on a slicer?

It seems you want field parameters, please refer to

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

I made a sample for your reference, you could download it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[jak8282]

Hi Stephen, 

Unfortunatly that didnt work - I am looking at adding two fields based on a selection from a paramater.

Thanks

Chris

[jak8282]

Thanks Stephen - Ill have a look - do you know why the selectedvalue  would return nothing when putting the value in a variable - if I have the selectedvalue as a measure on its own it seems to work fine?

The issue is we are trying to change two columns in a matrix based on the selected parameter.

[jak8282]

I thought about using a calculated column like below however it is returning blank.

Selected Rating Column = 
VAR SelectedRating = SELECTEDVALUE('Comments Switch'[Name])
RETURN
SWITCH (
    SelectedRating,
    "Exam booking process", 'Exam Experience Survey'[EXPROEVAL1_Exam booking process rating],
    "EXPROEVAL1_Examination Dockets rating", 'Exam Experience Survey'[EXPROEVAL1_Examination Dockets rating],
    "EXPROEVAL1_Pre session communications rating", 'Exam Experience Survey'[EXPROEVAL1_Pre session communications rating],
    BLANK()
)

**** On further investigation it seems SELECTEDVALUE returns blank for somereason while in a calculated column ???