Forum Discussion

aashton's avatar
aashton
Icon for Helper V rankHelper V
4 years ago
Solved

Using a stacked bar chart as a thermometer

Hello, I would like to show total gross margin by region, so I am using a stacked bar chart, but would like to show how far they are from the goal gross margin (similar to a thermometer).  So using ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi aashton 

     

    You can create a new table by unioning a new row and original table. In the new row, it calculates the difference between the total and the goal value.

     

    Then use this new table to populate the visual. The new Gap will also display as a Region, so it may be a little confusing if a reader doesn't know its meaning.

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi aashton 

 

You can create a new table by unioning a new row and original table. In the new row, it calculates the difference between the total and the goal value.

 

Then use this new table to populate the visual. The new Gap will also display as a Region, so it may be a little confusing if a reader doesn't know its meaning.

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.