Forum Discussion
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...
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
Thanks for your response Kelly. However, there would be situations where YTD goal will be less than Volume YTD. In that scenario how will we show both?
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