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 :
Go to Solution.
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.
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Find out where you can attend!