Currency Conversion is not working for Graph's in which having multiple countries

[sarjensystems1]

Hello All,

I am facing an issue while trying to get values for selected Currency, But not getting  for Graph's in which I am displaying sales to other countries from Selected Country.

For example, in the very first Screenshot I just Selected Netherland (from Country) to get Sales for '18-06-2021'.But when I am selecting Currency to get the value based on Currency Conversion for selected date it's working fine for all other graphs but not working for graph's having Sales for 'To Country'.

Like in the second SS the value of Amount & Quantity is same as in First SS. which means currency conversion is not working because it has country in axis, And it's getting confused like which country's currency to take by default.
Any idea please?

[v-yalanwu-msft]

Hi， @sarjensystems1 ；

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @sarjensystems1 ;

You could use if() or switch() dax to achieve the currency conversion. so if could you provide more screenshots and scenes about your problem in order to better solve the problem?  

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please show a sanitized version of your data model.  Do you have a table with monthly FX rates?