Forum Discussion

itsmeanuj's avatar
itsmeanuj
Helper IV
6 years ago
Solved

Need help with Visualization

    I have 3 columns in the data  Volume YTD Goal YTD 2020 Goal 2000 2200 30000   I want to create a horizontal bar chart (see attached sample) out of these values to show the...
Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi itsmeanuj ，

     

    Then measures need to be corrected as below:

     

    2020 Goal1 =
VAR a =
    MAX ( 'Table'[2020 Goal] )
VAR b =
    MAX ( 'Table'[Goal YTD] )
VAR c =
    MAX ( 'Table'[Volume YTD] )
RETURN
    IF ( b > c, a - b, a - c )
    Goal YTD1 = ABS(MAX('Table'[Goal YTD])-MAX('Table'[Volume YTD]))
    Volumn YTD1 = IF(MAX('Table'[Goal YTD])>MAX('Table'[Volume YTD]),MAX('Table'[Goal YTD]),MAX('Table'[Volume YTD]))

     

     

    The related .pbix file,pls click here.

     

    Best Regards,
    Kelly