Forum Discussion

shubhamc_002's avatar
shubhamc_002
Helper I
3 years ago

Dynamic Matrix visual based on selected slicer values

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

 

Need Help

2 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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], ", "))