Dynamic Value selection in PWBI matrix

[deys]

Hi,

I am seeking a help create a matrix in PWBI with dynamix Values. I want user to select or unselect out of three options of 1) Presence 2) Segment 3)Comments through a slicer and design custom matrix. All these columns are text not any values.

Attached is the PWBI file.

Any help will be appreciated.

Cheers.

[v-yinliw-msft]

Hi @deys ,

Can you provide sample data for testing? Sensitive information can be removed in advance.

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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

[Greg_Deckler]

@deys Don't see the file. You can create a single measure that uses SWITCH to return different values for different selections. Otherwise, not sure what you mean.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.