Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello
does anybody know any tables or visuals to enable me to format the data in the same was as the image below
How i want it to be formatted like
How i currently have it formatted
Is this possible or would i have to do 4 seprate tables one for each value heading?
Solved! Go to Solution.
You can use a Matrix Visual and turn on the "Show on Rows" option under Value section. It will show the measures in rows as you expected.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Actually, any Excel table can be added to Power BI including all formatting settings. This video shows how it can be done:
How to create any Excel table in Power BI using the HTML & CSS Viewer Visual
https://youtu.be/6JYVqE4UK7M
Hey @Ivolution93
You can apply conditional formatting to each column based on the values you want to apply background color.
Did I answer your question? Please mark this as solution
Best Regards
Jay Patel
iXpert Analytics
You can use a Matrix Visual and turn on the "Show on Rows" option under Value section. It will show the measures in rows as you expected.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.