Microsoft Power BI Quick Start Guide
by Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana
Show value as
Earlier in this chapter, we went through an example to take advantage of Conditional Formatting. This option can be found by hitting the downward arrow next to a field that is being used in a visual. Within this area is where we will find another option that is labeled Show Value As. This option will only be available for numeric data types, and allows us to show the values as a percentage of the grand total. The best way to take advantage of this is to place an identical column side by side and then use this option to display one of them as a percentage. For our example, lets revisit the Matrix visual we created for the Tabular Data section. Locate the Profit measure in the Fields Pane and drag it into the Values section for ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access