![\"Format](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/1Format-Table-Data-to-Show-Horizontally-in-Power-BI-1.png\")
<\/p>\n
We explored more to figure out that we can\u2019t format tables to show values horizontally. So, as a workaround, using a matrix, we formatted the table to display data horizontally.<\/p>\n
Here, is how it is done-<\/p>\n
1. At first, we need to select Matrix to display data instead of a table<\/p>\n
![\"Format](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/2Format-Table-Data-to-Show-Horizontally-in-Power-BI-1.png\")
<\/p>\n
2.<\/strong> Now you need to select the fields that you want to show in the table. In our case we are showing Account name (name) as a Column, Account Number (account number), and Email (emailaddress1) as a Value.<\/p>\n When we added a text field to the \u2018values\u2019 area, the fieldname was displayed as \u2018First FieldName\u2019 instead of \u2018FieldName\u2019. It also showed the field name as \u201cFirst account number\u201d and \u201cFirst emailaddress1\u201d. So, both field names are renamed.<\/p>\n By default, the selected property for the text field is \u201cFirst\u201d.<\/p>\n Why did it show \u201cFirst Field Name\u201d instead of \u201cField Name \u201c?<\/strong><\/p>\n We used the matrix so it grouped the result based on the \u201cColumn\u201d value. In our example, the column name is \u201cName\u201d (i.e. Account Name) so it grouped the result by \u201cAccount Name\u201d value.<\/p>\n We added Account Number under values and selected property as \u201cFirst\u201d (i.e. First Account Number). Because of this grouping on\u00a0Account Name,<\/strong>\u00a0it showed only the first Account number where multiple Accounts had the same name.<\/p>\n \u00a0Table<\/strong>: Sample data<\/p>\n Using Matrix<\/strong>:<\/p>\n So, according to your requirement you need to select property like First, Last, Count, Count (Distinct) and if you want rename the field column name.<\/p>\n 3.<\/strong> In final steps you need to turn on \u201cShows on rows\u201d property under Values in Format tab. Please follow our below screenshots:<\/p>\n 4.<\/strong> Now as you can see in our below screenshot our table data Account Number and Email are formatted horizontally and showing by Account Name.<\/p>\n By using Matrix feature of Power BI<\/a>, we can aligned values in table horizontally.<\/p>\n Did you ask how? Join us at crm@inogic.com<\/a> and our Team of experts at Inogic- Professional Services shall make the transformation a cakewalk! Introduction In a recent business requirement, we were requested to display account details (account number, Email) horizontally by \u201cAccount Name\u201d in the Power BI Report. When we selected a table to display data in our\u00a0Power BI\u00a0report, it displayed data vertically by default. We explored more to figure out that we can\u2019t format tables to show\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":15253,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,18,19,45],"tags":[1339],"class_list":["post-15244","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-power-bi","tag-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/15244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=15244"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/15244\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/15253"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=15244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=15244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=15244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/Power-BI-2.png\")
<\/p>\n![\"\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/Format-Table.jpg\")
<\/p>\n![\"format](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/format-table1.jpg\")
<\/p>\n\n
![\"format](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/format-table2.jpg\")
<\/p>\n\n
![\"format](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/format-table3.jpg\")
<\/p>\n\n
![\"format](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/format-table4.jpg\")
<\/p>\n![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/6Power-BI.jpg\")
<\/p>\n![\"\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/03\/7Format-Table-Data-to-Show-Horizontally-in-Power-BI-1.png\")
<\/p>\nConclusions<\/strong><\/h2>\n
\nImagine, Believe, and Achieve with our technical expertise and functional experience<\/p>\n","protected":false},"excerpt":{"rendered":"