show values in different formats in a line chart

[Anonymous]

I have a table as this:

A should be shown as whole number;

B should be shown as percentage.

I want to build a line chart like this:

The problem is

if I use "Modeling"---"%", it will change both of the line.

If I use a measure as :

showpercent = IF(

CONTAINS('Table1','Table1'[Name],"B"),

FORMAT( SUM('Table1'[Values]), "0.00%"),

FORMAT(SUM('Table1'[Values]),"0")

)

The measure can not use in the line chart's value filed.

Please help, thank you!

[dax · Accepted solution]

Hitatasherry,

I assume that your data sample might be similar to below

Then you could create measures like below

A = CALCULATE(SUM(F1[valeu]),FILTER(F1, F1[name]="A"))

B = CALCULATE(SUM(F1[valeu]),FILTER(F1, F1[name]="B"))

Then click on B and format this by click %

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.