Forum Discussion

jscottNRG's avatar
jscottNRG
Helper II
7 years ago

Dynamic rows, columns and values in matrix

I'd like to create a matrix visual that allows users to compare data by different intersections of attributes.  Specifically, I'd like the users to be able to see the average values of different new ...
Need Help
jscottNRG's avatar
jscottNRG
Helper II
7 years ago

Hi v-chuncz-msft, thanks for your help.

 

I'm afraid I'm still not clear what changes should be made to to the <Expression> part of SWITCH to achieve what I need.  Could you please suggest edit(s) to my code? I think you're suggesting that I add to the

SELECTEDVALUE('attribute_slicer (1)'[Attribute],"")

term of the HERS Average measure, but I'm unsure how to tie in 'attribute_slicer (2)'[Attribute].

 

Thanks again.

J

jscottNRG's avatar
jscottNRG
Helper II
7 years ago

I'm still hoping that someone experienced might be able to help with this, any suggestions?

  • jscottNRG's avatar
    jscottNRG
    Helper II
    7 years ago

    Hi all,

    I'm commenting on my question again to bump it to the top of the list.  If anyone has guidance on this - even to say that it's not possible - I'd very much appreciate it.  I'm unable to continue on my report until I get this issue solved and would like to be able to communicate to the executive team whether or not this visual is possible as I've described.

    Thanks in advance,

    J

    • jscottNRG's avatar
      jscottNRG
      Helper II
      7 years ago

      One more try!  Please advise if anyone has guidance on what I'm trying to accomplish here.  If it's not possible I will scrap this report and explore other options.

      Thanks,

      J