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
