Dynamic Matrix visual based on selected slicer values

[shubhamc_002]

Hi Team, 

We have one requirement in which wanted to show selected values from slicer (comma separated) in matrix visual but the condition is that should show only of values are selected from corresponding slicer. 

eg: 

if Slicer Country have selected values as India, China than matrix visual should display values as accordingly and another slicer selection is Department as Medical ,Instrumental than it should show as below. Similarly if other slicer selections are there then it should show data accordingly . 

Column A      | Column B
Country         | India, China
Department   | Medical ,Instrumental
Slicer_Name   | Val1, Val2....

if no slicers are selected then both columns should blank.

Thanks

[Anonymous]

Hi,

You can use the below sample measure for each slicer and show them as values in the matrix format.

concat_country = calculate(CONCATENATEX(DISTINCT(Sales[Country Name]),Sales[Country Name], ", "))

[v-jianboli-msft]

Hi @shubhamc_002 ,

What does your raw data look like?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

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