Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

How could implement selecting columns which shows in table dynamically?

Hi, I have requirment as follow: we have a table : A1 A2 A3 M1 M2 M3 we need to give to user possibility...

AllisonKennedy
6 years ago
Anonymous It is a bit unconventional but you can try to unpivot all the A and M columns, so that you are left with:
C, Attribute, Value

Also create a disconnected table (no relationships to current data model) for the M values that you want user to select. I called this table Slicer.
Slicer:
Select
M1
M2
M3

Then create the matrix with C in Rows, Attribute in Columns, Value in Values.

Finally, create this measure to filter the Attribute:

ShowColumns =
Var SlicerSelection = VALUES(Slicer[Select])
Var AlwaysShow = {("A1"), ("A2"), ("A3")}
Var ShowValues = UNION(SlicerSelection, AlwaysShow)
RETURN
IF(SELECTEDVALUE('Table'[Attribute]) IN ShowValues, 1, 0)

Put a filter on the visual for Attribute using Top N and use the ShowColumns measure as the By Value to filter for Top 1.

Anonymous

Not applicable

6 years ago

Thank you AllisonKennedy for the solution .

I follow the steps but the value of measure is always 0! and the solution does not work.
here are my tables :

and I created measure as follow:

ShowColumns =

Var SlicerSelection = VALUES(Slicer[Column1])

Var AlwaysShow = {("A1"); ("A2"); ("A3")}

Var ShowValues = UNION(SlicerSelection; AlwaysShow)

RETURN

IF(SELECTEDVALUE('Table'[Attribute]) IN ShowValues; 1; 0)

do you have any Idea?

I appreciate your help on this matter.

Regards,

Matin

AllisonKennedy
Community Champion
6 years ago
How have you configured the matrix visual? The measure will only work if there is only 1 Attribute selected, so you need to have attribute in Columns in the Matrix, and put this measure as the visual level filter as I explained in my previous reply, as a 'top N' filter. Can you share image of your report visual page Visualizations and Filters Pane to see what fields you've put in the visual? Redact any confidential info from the visual.
- Anonymous
  Not applicable
  6 years ago
  AllisonKennedy
  here is my Matrix configuration and Filter :
  - AllisonKennedy
    Community Champion
    6 years ago
    Make sure the Top N is set to Top 1. Sorry I should have specified in original post. I have updated now.