Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
@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.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi @AllisonKennedy,
Kindly find the attached google drive link. I hope it works for you.
Thank you for your support.
Regards,
Ahsan
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).
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |