Forum Discussion

baiju's avatar
baiju
Frequent Visitor
8 years ago
Solved

Row to Columns values with formatting

I have an excel data source which has Account related information.  columns include Account Name, Account Market, etc.. The requirement is to show the Each Account account row values in a column as showing in the reference image below. 

 

 

 

I tried to use Multi-Card visual And got below structure

 

 

Here, columns cames ( category lables in the card visual) coming to bottom and the hyperlinks are not working. Do we have any other visual which will give expected output as in reference image or any formatting we can do using dax?  

 

Thanks in advance.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    You can using the Matrix visual.  On the Values section of formatting, click "Show on Rows".

     

    That should give you what you're looking for: a 2 column table.  Left column is measure name, right column is value.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    You can using the Matrix visual.  On the Values section of formatting, click "Show on Rows".

     

    That should give you what you're looking for: a 2 column table.  Left column is measure name, right column is value.

    • baiju's avatar
      baiju
      Frequent Visitor
      8 years ago

      Thanks. Will try the same.

  • baiju's avatar
    baiju
    Frequent Visitor
    8 years ago

    I have an excel data source which has Account related information.  columns include Account Name, Account Market, etc.. The requirement is to show the Each Account account row values in a column as showing in the reference image below. 

     

     

     

    I tried to use Multi-Card visual And got below structure

     

     

    Here, columns names ( category labels in the card visual) coming to bottom and the hyperlinks are not working. Do we have any other visual which will give expected output as in the reference image or any formatting we can do using dax?  

     

    Thanks in advance.