Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
9 years ago

Line chart with shaded area?

I would like to make a chart like this:   Where there is a shaded goal area, and then a line.   The goal area is NOT hard coded, it needs to be set be mapped against a measure.  In the abov...
Need Help
OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
9 years ago

Yeah, I tried that too and ran into issues with bar gaps that I know would really distract and confuse the users so... I just gave up on that :(

 

I did post a question about anyway to hide gap though.

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi OneWithQuestion,

 

I have tested it on my local environment using the sample data below.

We can get the expected result like below.

 

 

Regards,

Charlie Liao

  • OneWithQuestion's avatar
    OneWithQuestion
    Post Prodigy
    9 years ago

    Sadly, that still shows a shaded area under the line.

     

    Ideally one would be a line and the other would be a shaded area (or column bar chart with adjusted gap width)

    • v-caliao-msft's avatar
      v-caliao-msft
      Microsoft Employee
      9 years ago

      Hi OneWithQuestion,

       

      Currently, this the closest workaround we can achieve in Power BI, if this is not what you want, you can create a custom visual to achieve it if you have rich experience in coding.

       

      Regards,

      Charlie Liao

  • pdi's avatar
    pdi
    New Member
    9 years ago

    Hi v-caliao-msft,

     

    Thanks for this solution. How did you get the Difference series to start at 1000?

     

    Thanks much !

    • pdi's avatar
      pdi
      New Member
      9 years ago

      v-caliao-msft Don't worry - got it ! Stacked area-chart....