Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
itsmeanuj
Helper IV
Helper IV

Need help with Visualization

image.png

 

 

I have 3 columns in the data 

Volume YTDGoal YTD2020 Goal
2000220030000

 

I want to create a horizontal bar chart (see attached sample) out of these values to show the progression. Can you please help me with this. I am not sure if we have similar visuals in PBI

1 ACCEPTED SOLUTION

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

View solution in original post

8 REPLIES 8
v-kelly-msft
Community Support
Community Support

Hi @itsmeanuj

 

I‘m afraid there isn't a visual that can show exactly the same as you need,but I can show you a workaround.

First, create 2 measures :

 

Goal YTD1 = MAX('Table'[Goal YTD])-MAX('Table'[Volume YTD])
Goal YTD1 = MAX('Table'[Goal YTD])-MAX('Table'[Volume YTD])

 

Then choose the visual :"stacked bar chart",and put measures and column you need in the visual field:

72.png

 

Finally you will see :

 

73.png

 

For 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

Anonymous
Not applicable

You can use Bullet Chart 2.0.1 or Bullet chart by OKViz

 

There you can specify the target, projection and actual along with color

 

https://www.youtube.com/watch?v=HU41079_tTI

https://www.youtube.com/watch?v=mtvUNl9bMjA

irobba
Helper I
Helper I

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.

SivaMani
Resident Rockstar
Resident Rockstar

@itsmeanuj,

 

Please do check it in Custom visuals.

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&page=1

 

Hope it will help you!

 

Regards,

Siva Mani

tex628
Community Champion
Community Champion

I believe that if you want to display the values correctly you will need to use a Clustered bar chart:

image.png

Is this layout acceptable or does it need to be a stacked bar chart? 

Br,
J


Connect on LinkedIn

Hi,

 

Actually I am doing it for a client and they wants to see it in a stacked chart.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors