Transpose table and change the view of table

[Anonymous]

Hi all,

I am facing one issue where I would like to transpose the table (Columns will look like rows, and it will also show row values in rows). And change the view of the table. So, currently, I have a table in PBI that looks like that. 

But I would like to see it like the below-mentioned image.

Is there any possibility to shift the Power BI table to like the above-mentioned image? Thank you all for your kind support.

Regards,

Ahsan

[Anonymous]

@AllisonKennedy, Can you please guide me more about the custom DAX to get the exact formatting? Speed is not an issue for me because I'm not using a big dataset, I have only a few data points, but the main target is to show the values as I stated in the question. I'm not a pro in Power BI, so your help is beneficial for me. Thanks

[AllisonKennedy]

@Anonymous Can you share the raw data or sample of it using OneDrive please? Custom DAX would look something like: 

Subsidiary Name = "* Name of Subsidiary: " & [Subsidiary Name]

Then you can use multi-row card or data story visuals to add all the measures to it. https://blog.pragmaticworks.com/power-bi-custom-visuals-enlighten-data-story You can use html <br> for new line in that data story one. 

[Anonymous]

Hi @AllisonKennedy, 

Kindly find the attached google drive link. I hope it works for you. 

Example Data set 

Thank you for your support.

Regards,

Ahsan

[AllisonKennedy]

You could try a matrix instead of table visual. You might find the 'show values on rows' feature helpful.

Otherwise you could try smart narrative custom visual or use custom DAX to get the exact text formatting you want (DAX may be slow).