Scott Ho

My feedback

  1. 150 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Scott Ho commented  · 

    I am currently developing a Sales report for a multi-national company who has shops from around the world. The Headquarters in Europe wants to see Sales reports in EUR as that's what makes sense to them. However, a big share of the retail revenue is coming from Australia in transaction currency in AUD. Headquarters also fixes the exchange rates that we need to use for reporting purposes. The daily currency market movement is irrelevant as financially reporting is done only monthly. I didn't want to create two different measures like Actual MTD and Actual MTD (EUR). I preferred to use only one measure called Actual MTD.

    When we deal with currencies, we always talk currency value and symbol to make sense. So naturally I had to add two parameters and control the calculation and DISPLAY of the Actual MTD:

    ShowEuroCurrencyValue = TRUE
    ShowEuroCurrencySymbol = TRUE

    But the second parameter would expose this Power BI limitation in formatting (converting numeric to text). The solution I came up is instead of changing the format on the measure itself, I had to add a Card on the page at the top to show viewers either AUD or EUR.

    Scott

    Scott Ho supported this idea  · 

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.