Forum Discussion

tommyt's avatar
tommyt
Regular Visitor
4 years ago

Conditionally rename row in Matrix

Hello Users!
Is it possible to conditionally rename a row in a matrix based on a slicer selection?  For example, in my example here, whenever a user selects 'Omaha' as a city, I'd like the text to change in an individual attribute as shown here (note: the highlighting appears here to for illustration purposes only,  that is to say my goal is for 'Phone' to change to 'Phone (Warranty included)' )

Thanks in advance,

 

Need Help

1 Reply

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

    Hi tommyt ,

     

    This is currently not supported. A workaround is to add all the selectable columns and then create the field parameters.

     

     

    Create measure to filter the columns.

     

    Measure = 
IF (
    "Omana" IN VALUES ( 'Table'[City] ),
    COUNTROWS ( FILTER ( Parameter, [Parameter] = "ItemName2" ) ),
    COUNTROWS ( FILTER ( Parameter, [Parameter] = "ItemName1" ) )
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.