Forum Discussion

F_Reh's avatar
F_Reh
Icon for Post Patron rankPost Patron
2 years ago

Third Metric on a Visual ?

Good Afternoon,   I have a visual below, where I am using seconday Y-axis (in addition to the X and Y axises). The orange line denotes a % (seconday Y-Axis), while the pale yellow columns denote th...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

 

You can use custom label, with all 3 measures concatenated into one.

I used this data to recreate your scenario:

where Concat is calculated column and equal to:

Concat = "Denominator: "& 'Table'[Denominator]&
" Numerator: "&'Table'[Numerator]& ","&
" Percent: "&format('Table'[percent], "Percent")
 
On the chart in Format section -> Data labels ->values toggle ON Custom label and use Concat column: