Forum Discussion

deys's avatar
deys
New Member
4 years ago

Dynamic Value selection in PWBI matrix

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.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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.

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.