Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |