Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Coming chart issue

Hello experts, i need help in finding solution or workaround for an issue. so I have a cluster column line chart where x axis is text type, left Y axis for column is amount in thpusands ranging fro...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    maybe this dirty trick will help

    PBIX

     

     

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ,

 

How to get the value of around 40%?Can you upload a pic showing the line in Tableau ? Based on the data you showed in the post,the line should be as below:

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Kelly,

the data I post only 3 rows from dataset. I have thousands of rows. And as I mentioned, I do not know the backend calculation for baseline. The average amount for baseline is coming as 900.

do you thing Xviz multiple axes chart might work here?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ，

     

    I‘ve tried Xviz multiple axes chart,but seems not a good solution for you,see below:

     

    As you said in the last reply,the sample data has only 3 rows from dataset,but there are  thousands of rows actually.So just try the method we suggested,you may get the value you need.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!