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

irobba's avatar
irobba
Helper I
6 years ago

Hi there, 

 

You could potentially achieve the visual look with a bar chart by creating measures that calcualte the difference between the values and plotting them on the chart, rather than the actual values. 

 

Vol to Goal YTD = MAX([Goal YTD] - [Vol YTD],0)

Vol to Goal 2020 = MAX([Goal 2020] - MAX([Goal YTD], [Vol YTD]),0)

 

The MAX functions are there to make sure you don't plot negative values when your actual overtakes your goal. 

 

Difficulty with this though will be with the labelling, as the value on the chart for Goal YTD for instance will be 5000 rather than 15000. Purely the chart aspect will look ok though and you could possibly get creative with some cards or just rely on the axis and grid lines for value labels. 

 

I'd suggest as an alternative though looking at the bullet chart visual on the marketplace or something similar which is specifically designed for plotting values against target values and may give you a better and more meaningful result. Also worth exploring some of the gauges and looking at alternative approaches. There's plenty of good ones freely available through the Marketplace.