Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Column Change based on selection

Hi Experts,   I am working on matrix table it should display columns based on selection in slicer.   For Eg:-   Graphical Representation: -     In the above two diagrams, assume left vi...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Anonymous 

     

    I think it is normal. If you put a value in 'Value', it will show a list of value for each 'Attribute'. As a workaround, you may create a measure like below. The pbix file is attached in the end.

    Result = 
IF(
    SELECTEDVALUE(New[Attribute]) in {"Category","Drawer","Header A","Header B"},
    MAX(New[Value.1]),
    SELECTEDVALUE(New[Value])
)

     

    Result:

     

    Best Regards

    Allan

     

    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
5 years ago

Hi Allan,

 

Thanks for the reply. Funtionality wise your solution is good. 

Please find the below screenshot

 

When I drag the Value inside values space in matrix it shows for every column.

Value field always should display at last as total.  Only one column. 

 

 

 

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, Anonymous 

 

I think it is normal. If you put a value in 'Value', it will show a list of value for each 'Attribute'. As a workaround, you may create a measure like below. The pbix file is attached in the end.

Result = 
IF(
    SELECTEDVALUE(New[Attribute]) in {"Category","Drawer","Header A","Header B"},
    MAX(New[Value.1]),
    SELECTEDVALUE(New[Value])
)

 

Result:

 

Best Regards

Allan

 

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