Forum Discussion
Format Table Like Excel - Visuals
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?
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.
3 Replies
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.
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 AnalyticsActually, 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
