Dynamic Row header change from slicer selection

[prakash11440278]

Hi Team,

My requirement is to change the row headers dynamically if i switch the filter from yes & no.

If yes means Mine% column need to display and no means Mine. Please help.

Thanks in advance.

[v-jingzhang · Accepted solution]

Hello @prakash11440278

Are these two columns of different tables? If so, you can create a new table with the following DAX code, and then place the Mine and Value columns of this new table in a table visual and place the YesOrNo column in a slicer to filter the values in the table.

NewTable = UNION(SUMMARIZE(TableNo,TableNo[Value],TableNo[Mine],"YesOrNo","No"),SUMMARIZE(TableYes,TableYes[Value],TableYes[Mine%],"YesOrNo","Yes"))

Best regards

Community Support Team _ Jing Zhang

If this post helps,please consider Accepting it as the solution to help other members find it.

[camargos88]

@prakash11440278 ,

I don't know if I get it right....

You can create a column for each dataset with the information (YES/NO) and append both tables. So when you change the slicer you get different values.