Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI Matrix visual with SELECTEDVALUE text values

Hi,

I have a matrix visual with texts in value field (as I need them to be on the same line).

CutomerName= ('Customer'[Customer Name])

 

I use SELECTEDVALUE measure, however I need to display SelectedValue "textmeasure" for "order number" level but not to display under "order subline" subcategory level.

For example I need to have Sales amount for each "order subline" level, but the name of customer only on the level of order number and not to repeat it under each order subline. 

 

Thank you in advance for your help.

Need Help
Tips and Tricks

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi Anonymous ,

     

    Try the following measure:

    Customer = IF(ISINSCOPE(Table[Order]), ('Customer'[Customer Name]))

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Felix, thank you for your reply. This solution gives the same result: it repeats the customer name both on the level order number and on subline levels.

     

     

    • MFelix's avatar
      MFelix
      Super User
      3 years ago

      Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

      If the information is sensitive please share it trough private message.