Forum Discussion

Asahara20's avatar
Asahara20
Regular Visitor
4 years ago

How to multi select values in filter and display values as nested in matrix visual

Hi Team,

I hope someone has an idea on how we can deal with this issue.

 

We have a table, and using the existing table I have created a new table to use selected columns and combine those columns into one column using union function.

 

I did this because I need column headers as filter so we can toggle between different columns.

 

Now I have used the new column from the new table in the filter visual that has all column header names. (Here I have also created some measures so I can select the value that I need)

 

Now, if i single select each of those values then it displays the data correctly in the matrix visual based on the selected value.

 

But my requirement is if I have to select 2 values in the filter section , the matrix visual is showing the data in the linear format instead of nested one value inside the other.

 

Can you please let me know how can resolve this issue?

 

Thanks

1 Reply

  • Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.